Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

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
Memorable Member
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.

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.

Connect on LinkedIn
Anonymous
Not applicable

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.