My sales data is reported in two units of measurement: (1) Physical Cases (2) 9L Cases. Example:
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
Go to 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:
View solution in original post
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.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!