Forum Discussion

joshua1990's avatar
joshua1990
Post Prodigy
6 years ago

Dynamic title

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?

 

 

Need Help

4 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    6 years ago

    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's avatar
      joshua1990
      Post Prodigy
      6 years ago

      Thanks a lot Fowmy !

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

       

      • Fowmy's avatar
        Fowmy
        Super User
        6 years ago

        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