Switching between units

[Anonymous]

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 button that can show these percentages and then also the underlying abosolute units please.

[Icey]

Hi @Anonymous ,

I think you've found the solution, haven't you?

If you have, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

Best Regards,

Icey

[Icey]

Hi @Anonymous ,

How about using Tooltip?

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

You can use a slicer to change measure

refer : https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

Or refer bookmark

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

[Anonymous]

@amitchandak thank you! I think the slicer technique shoould do the trick.

[MFelix]

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]

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]

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]

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