Forum Discussion
Dynamic chart title based on language slicer
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?
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
5 Replies
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!
Hi SwarnaTeja this works for a single chart, but I have multiple charts — what should I do in that case?
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 Thank you SwarnaTeja it worked
