topic Re: Dynamic title in DAX Commands and Tips

Dynamic title

joshua1990 — Sun, 02 Aug 2020 11:46:49 GMT

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 — Sun, 02 Aug 2020 11:57:45 GMT

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 — Sun, 02 Aug 2020 12:51:36 GMT

Thanks a lot Fowmy !

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

Fowmy — Sun, 02 Aug 2020 13:13:50 GMT

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 🙂

Greg_Deckler — Sun, 02 Aug 2020 13:58:58 GMT