Toggle Axis by a slicer

[Kalachuchi]

I have a table of sales below

Details

Client Name	Status	Staff	Supervisor
Test1	Completed	Arthur Morgan	Dutch van der Linde
Test2	Pending	Micah Bell	Karen Jones
Test3	Pending	Arthur Morgan	Karen Jones

I wanna see how many Staff and supervisor are still on pending.

I have created another table which holds the word staff and supervisor and created a switch statement

RankTable

Switch(TRUE()
    ,Values('RankTable'[Rank])="Supervisor",[Number of Supervisor]
    ,Values('RankTable'[Rank])="Staff",[Number of Staff]
  
    ,blank())

Measure: Number of Supervisor

Number of Supervisor= DISTINCTCOUNTNOBLANK('Details'[Supervisor])

Measure: Number of Staff

Number of Staff= DISTINCTCOUNTNOBLANK('Details'[Staff])

Output will have a bar chart which x axis depends on the switch between view of staff or supervisor and will show how count of staff who still has pending status.

[v-janeyg-msft · Accepted solution]

Hi, @Kalachuchi 

According to your description,I think you can modify your measure and use it in bar chart 'values'.

Like this:

Measure 2 = IF(SELECTEDVALUE(RankTable[Rank])="Supervisor",[Number of Supervisor],[Number of Staff])

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Kalachuchi , On of the option for that is bookmarks and buttons

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

Others Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/

[Kalachuchi]

@amitchandak ,bookmarks and button is what I was thinking but I have 3 more slicer so when there is already an active option on the other 3 slicer and user clicked the button slicer will reset everything.

[amitchandak]

@Kalachuchi , If you can add a direct Query table and test this

https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/