How to change the chart title according to the Slicer

[hemingt]

Hi Teams,

I have a stacked column Chart and a Slicer on the same page.

I want to let the Chart title changed according to the Slicer, the Chart title may like some text + Slicer selected value.

Is it possible?

Thank you very much!

[judspud · Accepted solution]

Hi @hemingt,

As far as i am aware you cannot dynamically change the title on a visual.

One work around would be to create a measure concatenating text and the value of the slicer and place this in a card visual just above the chart to mimic a title.

Hope this helps

Thanks,

George

[Anonymous]

@judspud This sounds pretty awesome! You have any example of a measure?

[judspud]

Since the OP asked the original question an update has allowed the use of dynamic titles on visualisations.

You can use the measures but instead of placing them in a card visual you can place them into the title field of the visualisation.

More info can be found here:

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-format-visual-titles

Hope this helps 🙂

Thanks,

George

[hemingt]

Thank you @judspud .

I got it.

[hemingt]

Hi @judspud 

Could you give an example? Thank you!