Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
afkhalifeh
Frequent Visitor

Changing Visual Title Dynamically-Power BI Desktop

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

1 ACCEPTED SOLUTION
v-xinruzhu-msft
Community Support
Community Support

Hi @afkhalifeh 

You can refer to the following solution.

I create the following sample tables.

Slicer table.

vxinruzhumsft_0-1716520092154.png

Title Table

vxinruzhumsft_1-1716520124958.png

Data table

vxinruzhumsft_2-1716520138565.png

Create a relationship between slicer table and language table.

vxinruzhumsft_3-1716520177150.png

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.

vxinruzhumsft_4-1716520346091.png

 

vxinruzhumsft_5-1716520359464.png

 

Then set each title to the following. select the title column.

vxinruzhumsft_6-1716520410642.png

 

 Output

vxinruzhumsft_7-1716520453812.png

 

vxinruzhumsft_8-1716520464056.png

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.

 

 

 

View solution in original post

2 REPLIES 2
afkhalifeh
Frequent Visitor

Hi, Thanks a lot. It's working 🙂

v-xinruzhu-msft
Community Support
Community Support

Hi @afkhalifeh 

You can refer to the following solution.

I create the following sample tables.

Slicer table.

vxinruzhumsft_0-1716520092154.png

Title Table

vxinruzhumsft_1-1716520124958.png

Data table

vxinruzhumsft_2-1716520138565.png

Create a relationship between slicer table and language table.

vxinruzhumsft_3-1716520177150.png

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.

vxinruzhumsft_4-1716520346091.png

 

vxinruzhumsft_5-1716520359464.png

 

Then set each title to the following. select the title column.

vxinruzhumsft_6-1716520410642.png

 

 Output

vxinruzhumsft_7-1716520453812.png

 

vxinruzhumsft_8-1716520464056.png

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.

 

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors