Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi,
I have around 35 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”. and so on.
Please note that the titles are saved in a table. The table contains the following columns: LanguageID, VisualID, Title.
I am looking for a solution (one measure) for all of the 35 visuals?
Thank you,
Abdul
Solved! Go to Solution.
Hi @afkhalifeh
You can refer to the following solution.
I create the following sample tables.
Slicer table.
Title Table
Data table
Create a relationship between slicer table and language table.
Then when create each visual, put the visual id to the visual filter.
e.g I create two visuals column visual and pie chart visual, in column visual, i filter the column visual equal to 1, and the pie chart equal to 2.
Then set each title to the following. select the title column.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, Thanks a lot. It's working 🙂
Hi @afkhalifeh
You can refer to the following solution.
I create the following sample tables.
Slicer table.
Title Table
Data table
Create a relationship between slicer table and language table.
Then when create each visual, put the visual id to the visual filter.
e.g I create two visuals column visual and pie chart visual, in column visual, i filter the column visual equal to 1, and the pie chart equal to 2.
Then set each title to the following. select the title column.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
82 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
129 | |
108 | |
63 | |
55 |