cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
k_rolling Frequent Visitor
Frequent Visitor

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:

 

ProductPhysical Cases9L Cases
Product #124
Product #236
Product #2510
Product #3510

 

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
k_rolling Frequent Visitor
Frequent Visitor

Re: Is it possible to use slicer for data conversion?

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

View solution in original post

2 REPLIES 2
VasTg Member
Member

Re: Is it possible to use slicer for data conversion?

@k_rolling 

 

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/20...

 

If this helps, Accept it as a solution.

Kudos are nice too.

k_rolling Frequent Visitor
Frequent Visitor

Re: Is it possible to use slicer for data conversion?

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

View solution in original post

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,952)