Forum Discussion

PoojaS5's avatar
PoojaS5
Frequent Visitor
3 years ago

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.

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

 

 

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

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