Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Switching between units

Hi all! I have a series of cards that contain values in percentages. These percentage values are derived from underlying absolute values (e.g. dollar sales by category). I'd like to have a toggle but...
Need Help
Show and Tell
MFelix's avatar
MFelix
Super User
6 years ago

Hi Anonymous ,

 

You need to duplicate the cards and change the percentages by units them make two buttons and two bookmarks, in one bookmar hide the percentages and in the other one hide the units, know just make the bookmarks action on the buttons.

 

https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi MFelix , thank you for your suggestion. I already have several buttons that link to bookmarks so adding even more would make the workflow overly complicated.

    • MFelix's avatar
      MFelix
      Super User
      6 years ago

      Hi Anonymous ,

       

      As you refere on your title that you want a toggle button that would be the solution.

       

      Another option can be the SWITCH function associted with a slicer and a measure that show one of the two values.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        You are right! I shall correct the title, thank you!