Dynamic title

[joshua1990]

Hello everyone!

I have a bar chart where I would like to switch/ toggle the title based on filter.

The filter has the following to fields "A" and "B".

I have tried to use this measure for a conditational formatting of the title:

Dyn Title = SWITCH([Filter Area], "A", "Total Dep", "B", "Subgroup" )

But this measure is not working. I can't add this measure to a cond. format.

Why?

[Fowmy]

@joshua1990 

Try like:

Dyn Title = SWITCH(SELECTEDVALUE('Table'[Filter Area]), "A", "Total Dep", "B", "Subgroup" )

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[joshua1990]

Thanks a lot @Fowmy !

But I think it is not possible to add a switch measure to a cond. formatting, right?

[Greg_Deckler]

@joshua1990 - Disable your Title and just use a Card Visual perhaps. https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Most-Amazing-Mind-Blowing-Dynamic-Slicer...

[Fowmy]

@joshua1990 

Did my solution work for you? Please accept as a solution.

Regarding the SWITCH in CF, yes it will work but needs to change.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn