Is it possible to use slicer for data conversion?

[Anonymous]

Hello,

My sales data is reported in two units of measurement: (1) Physical Cases (2) 9L Cases. Example:

Product	Physical Cases	9L Cases
Product #1	2	4
Product #2	3	6
Product #2	5	10
Product #3	5	10

My Power BI Dashboard reports only the Physical Cases. Is it possible to create a slicer that will allow my users to convert the dashboard data between "Physical Cases" and "9L Cases"? 

Thank you in advance for your help

[VasTg]

@Anonymous 

There are two approaches to do this.

1. Build two pages, one with Physical cases and the other 9L cases,bookmark the pages and use the pages in button Actions.

2. Create a table with two values - Physical Cases and 9L Cases, use them as a slicer and follow this post.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Measures-Titles-Using-SWITCH/td-p/200718

If this helps, Accept it as a solution.

Kudos are nice too.

[Anonymous · Accepted solution]

Thank you! The second solution led me to the correct keywords to quickly find a solution.

Here is the video which clearly guides how to create a new measure slicer and convert the data:

https://www.youtube.com/watch?v=gYbGNeYD4OY