Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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
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?
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |