cascading filters

[user83]

Hello 🙂

I want to add several cascading filters i.e., if I click on the filter A it shows me on the right the corresponding list, below the A, I would put the flitres B and click on the B, I have a list that opens next to the right and that shows me all the proposals.

I have a lot of filters A, B,C,D.

I can't find a visualsation that matches what I'm looking for, could you help me find a solution,

thank you very much

user83

[user83]

@amitchandak Thank you for taking time to understand the need.

I can't create a measurement (calculate) like the youtube example because my columns are considered as text.

A similar example (excel) and the expected result is below.

[v-yiruan-msft]

Hi @user83，

Are these filter fields from the same table? Please check if the methods in the following links can achieve your requirement:

Hierarchy Slicer

Cascading in Slicers

Cross-sync slicers and filters, using bookmarks

Best Regards

Rena

[amitchandak]

@user83 , I am not sure I got it.

But refer if these can help

https://community.powerbi.com/t5/Desktop/cascade-filter/m-p/761193

https://www.youtube.com/watch?v=cyOquvfhzNM