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

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.

Select Page 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.

Leave a Reply