Home » DAX » Dynamic Title for Multi Select values on visual

Dynamic Title for Multi Select values on visual

Dynamic Title for Multi select values

Power BI allows you to change the visual title Dynamically based on slicer selection values.





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

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

Visual

Visual

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

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

Dynamic Multi Select Title

Measure Description:

  • Var : Store the values
  • Values : returns a one column table that contains the distinct values from the specified column.
  • Concatenatex : click here to understand concatenatex working




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

function in Power Bi

function in Power Bi

Step-3: Now select title measure.

Select Measure

Select Measure





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

Select Value in slicer 1

Select Value in slicer 1

Select slicer value 2

Select slicer value 2

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

Refer Power BI other Topics: Power BI Tutorials




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