Forum Discussion
Is it possible to use slicer for data conversion?
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
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:
2 Replies
- VasTg
Memorable Member
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.
If this helps, Accept it as a solution.
Kudos are nice too.
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:
