Skip to content
Home » Power BI » Power BI – Dynamic Title name change on visuals

Power BI – Dynamic Title name change on visuals

Dynamic Title name change on visuals
5/5 - (1 vote)

In Power BI Desktop you can change the Visual title Dynamically on the basis of slicer selection value.




Note:

Download Sample Dataset: Excel Sample Dataset for practice

Let’s understand with an example:

Step-1: Sample data visual as below.

Power Bi Visuals
Power Bi Visuals

Step-2: Now Create Measure for Dynamic Title, Right click on Dataset then click to New measure.

Measures in Power Bi
Measures in Power BI



Step-3: After that one DAX formula screen appears, write measure here.

DynamicTitleName =
Var Region= SELECTEDVALUE(Orders[Region])
Var finalResult= UPPER(Region) & " REGION SALES PROFIT DATA"
Return finalResult
Create Measure
Create Measure

Step-4: Now link Measure with visual Title using conditional formatting.

For 2022 onwards version-

Select the chart> Click on Second Icon> Click on More Option> Enable Title from Format Pane> Click on fx Icon.

Dynamic Title Change Power BI 2023
Dynamic Title Change Power BI 2023

For old version Power BI desktop –

Select  Chart Visual then go to Format pane > Enable Title > click on three dot > then click on Conditional formatting.

Title Properties

Step-5: Now select Measure and click to OK button.

Conditional Formatting
Conditional Formatting

Step-6: Now Select any region from region slicer & see the visual title.

Dynamic Title 1
Dynamic Title 1



Now select another region-

Dynamic Title 2
Dynamic Title 2

Note: It will work only for single slicer section value at a time.

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our Contact form , we will revert to you asap.

Loading

2 thoughts on “Power BI – Dynamic Title name change on visuals”

  1. With something like
    Var Region = CONCATENATEX(Orders;Orders[Region];”, “)
    instead of
    Var Region = SelectedValue(Orders[Region])
    It would also work with more than a single slicer section value at a time.

Leave a Reply

Discover more from Power BI Docs

Subscribe now to keep reading and get access to the full archive.

Continue reading