Change value in table based on slicer which has two fields

PoojaS5 — Mon, 20 Mar 2023 15:15:48 GMT

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)

Date	Region	Mode	Gross status	Net status
11/03/2022	USA	Air	Met	Not Met
17/03/2022	Canada	Air	Met	Not Met
15/04/2022	Canada	Ocean	Not Met	Met
27/04/2022	EU	Ocean	Not Met	Not Met
06/05/2022	Chicago	Air	Met	Met

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.

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

Re: Change value in table based on slicer which has two fields

amitchandak — Tue, 21 Mar 2023 03:31:30 GMT

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) )

topic Change value in table based on slicer which has two fields in DAX Commands and Tips

Change value in table based on slicer which has two fields

Re: Change value in table based on slicer which has two fields