Slicer like in Excel

[joshua1990]

Hello everybody!

I have added some filters in the horizontal view.

Now it looks like in excel.

Unfortunately, the handling is different.

In excel, when I filter or select a value in a slicer the other slicers are get filtered based on this selection.

So, every slicer is dependent from the others. I mean, this is a top-down-approach.

Is there any way to get this in Power BI?

[amitchandak · Accepted solution]

@joshua1990 , Slicer will filter each other if they are from the same table.

If you want filter from two different table

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

[nvprasad]

Hi

PowerBI slicers also work in the same manner. However, if your slicers from the two different tables then establish a relationship to get the expected output.

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad