Change Reprt Title bsed on a filter selection

[Anonymous]

Hi!

I want to change the title of my report based a particular filter I have .

Basically if the filter is on "A", I should show "Text 1" and if I seelect "B" it should show " Text 2". The text 1 and 2 are just random text that I want to put. 

Help will be greatly appreciated.

[MattAllington · Accepted solution]

You need to write a measure that returns the text you want. You could use something like this

title = switch(selectedvalue(table[column]),"A","text 1","B","text 2")

then go to the chart title setting, click on the 3 dots (hidden unless you hover), and set the conditional format based on the measure

[Mariusz]

Hi @Anonymous 

If you referring to Page Name, the simple answer is it can not be done.

But you can add it as an Idea if it hasn't been added yet.
https://ideas.powerbi.com/forums/265200-power-bi-ideas

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[MattAllington · Accepted solution]

You need to write a measure that returns the text you want. You could use something like this

title = switch(selectedvalue(table[column]),"A","text 1","B","text 2")

then go to the chart title setting, click on the 3 dots (hidden unless you hover), and set the conditional format based on the measure

[Anonymous]

How to handle when there is none selected or all selected?

[MattAllington · Accepted solution]

There are lots of options.

title 2 = switch(selectedvalue(table[column]),"A","text 1","B","text 2","you must select only one value")

or set the slicer to single selection only.