Changing Visual Title Dynamically in Power BI Desktop

[afkhalifeh]

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.

[TomMartens · Accepted solution]

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

[afkhalifeh]

Many thanks, Tom for the reply.

Is it possible to create one measure for all of the 4 visuals?