Forum Discussion

Dinz's avatar
Dinz
Regular Visitor
1 year ago
Solved

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?

  • Anonymous's avatar
    Anonymous
    1 year ago

    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 1Title 2Language 
    Chart TitleChart Title 2English
    Titre du graphiqueTitre du graphique 2French

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
    Dinz
    Regular Visitor

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

    • Anonymous's avatar
      Anonymous
      Not applicable

      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 1Title 2Language 
      Chart TitleChart Title 2English
      Titre du graphiqueTitre du graphique 2French
      • Dinz's avatar
        Dinz
        Regular Visitor

        Thank you Anonymous it worked