Dynamic chart title based on language slicer

[Dinz]

I want to add a filter or slicer that displays a list of multiple languages. Based on the language selected, the chart titles should automatically translate. I don’t want to create separate measures for each chart or maintain multiple reports for different languages. How can I achieve this?

[SwarnaTeja]

Hi @Dinz ,

Please try this.

Step 1: Create a table with titles and languages as below.

Step 2:

In the Chart Properties, use fx for Ttile and select the created Column. Then add a slicer with Language column.

Hope that helps!

[Dinz]

Hi @SwarnaTeja this works for a single chart, but I have multiple charts — what should I do in that case?

[SwarnaTeja · Accepted solution]

Please apply the same fx in properties of all charts. We can use table but different title columns for each chart. Just like below.

Title 1	Title 2	Language
Chart Title	Chart Title 2	English
Titre du graphique	Titre du graphique 2	French

[Dinz]

Thank you @SwarnaTeja it worked

[Rufyda]

great!