Forum Discussion
Changing Visual Title Dynamically in Power BI Desktop
I have 4 visuals; I need a way to change the title dynamically of each visual based on the selected value for a slicer and based on the visual name itself.
For example, the title of the visual one must be “No. of students” if the selected slicer is “en”, whereas the title of visual one must be “No. of students in French” if the selected slicer is “fr”.
For the 2nd visual, the title of visual must be “No. of customers” if the selected slicer is “en”, whereas the title of this visual must be “No. of customers in French Language” if the selected slicer is “fr”.
Please note that the I have saved titles in a table. The table contains the following columns: LanguageID, VisualID, Title.
Please help.
Hey afkhalifeh ,
you can create 4 measures, one for each visual. Then use each measure as dynamic title for a visual accordingly:
A measure might look like this:
vizAid vis1 title = var selectedLanguage = selectedvalue( 'languagetable'[LanguageId] , "<defaultlanguageId") return calculate( firstnonblank( 'languagetable'[Title] , 0 ) , 'languagetable'[LanguageId] = selectedLanguage , 'languagetable'[VisualId] = "the ID of the viusal" )Hopefully, this provides what you are looking for.
Regards,
Tom
2 Replies
Hey afkhalifeh ,
you can create 4 measures, one for each visual. Then use each measure as dynamic title for a visual accordingly:
A measure might look like this:
vizAid vis1 title = var selectedLanguage = selectedvalue( 'languagetable'[LanguageId] , "<defaultlanguageId") return calculate( firstnonblank( 'languagetable'[Title] , 0 ) , 'languagetable'[LanguageId] = selectedLanguage , 'languagetable'[VisualId] = "the ID of the viusal" )Hopefully, this provides what you are looking for.
Regards,
Tom
Many thanks, Tom for the reply.
Is it possible to create one measure for all of the 4 visuals?
