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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PoojaS5
Frequent Visitor

Change value in table based on slicer which has two fields

Greetings,

 

Below is the table where i have some sort of transit time condition status, which has 4 consecutive columns contains region, mode, gross status and net status.(where i have 20K+ line items)

DateRegionModeGross statusNet status
11/03/2022USAAirMetNot Met
17/03/2022CanadaAirMetNot Met
15/04/2022CanadaOceanNot MetMet
27/04/2022EUOceanNot MetNot Met
06/05/2022ChicagoAirMetMet

 

I want to create a table in powerBI where it has to show the status based on two slicers, where i need to include category as one slicer and statuses as one slicer.

PoojaS5_0-1679325109851.png

PoojaS5_1-1679325149371.png

so what i expect my output to look like is attached as reference,

which both the category and percentage has to be changed based on the slicer i choose,

percentage is nothing but the met status of the shipment on how much the month has achieved the performance

 

PoojaS5_2-1679325205717.png

 

1 REPLY 1
amitchandak
Super User
Super User

@PoojaS5 , better to unpivot columns Gross status, and Net status in the power query

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

 

Then you can have a measure

divide(countrows(filter(Table, table[Status]= "Met") ), countrows(Table) )

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.