Dynamic Title change for Multi select values on visual

Power Bi allows you to change the visual title Dynamically on the basis of slicer selection values.

So, Let’s start with an example, download the sample Dataset from below link:-

After that create two visuals : 1 – Slicer with Region, 2 – Clustered column chart, Region wise Sales

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 : concatenates the result of an expression evaluated for each row in a table using the specified delimiter.

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

Step 3: Now select title measure.

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

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

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

DAX Tutorials