Home » Power BI » Power BI Dynamic Title Based On Slicer Selection

Power BI Dynamic Title Based On Slicer Selection

In this blog you will understand “How to change the visual title Dynamically based on slicer selection values in Power BI?”

Let’s add two visuals into Power BI canvas as shown below screen shot.

1- Slicer Visual with Region fields.

2- Clustered column chart with Sales & region.

Power BI Visuals

Power BI Visuals

Following below steps to setup dynamic title change-

Step-1: Create a measure for dynamic title change on visual.

TitleTxt =
VAR GetValues= CONCATENATEX(
VALUES(Orders[Region]), Orders[Region], ", ")
RETURN
"Selected Region [ " & GetValues & " ]"




Measure Description:

  • Var : Store the values
  • Values : returns a one column table that contains the distinct values from the specified column.
  • Concatenatex : Is useful to concatenate string.

Step-2: Select visual > go to format bar > turned on Title > click to fx icon.

Title Function in Power BI

Title Function in Power BI

Step-3: Title Text windows appears, now select the title measure.

Select Measure in Power BI

Select Measure in Power BI




Step-4: Now select values from region slicer & see the chart title dynamic change behavior.

Select Value in Slicer

Select Value in Slicer

Select more Slicer Values

Select more Slicer Values

As you see, Title changing dynamically on selection of Region values.



Refer more Power BI Post – Power BI

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome.

Leave a Reply