cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

Multiple trickle down cascading filters

i have a main Filter that filters some pie charts and tables.  when i use this 1st filter one of my donut chart reduces to 3 slices, I now want to continue to filter down using this donut chart to other tables I have in my report.... BUT when I select the filtered donut chart, the original filter is 'turned off' or removed from entire viz...

 

how can i continue to filter down to other tables and charts without removing my original filter... i would call it cascading filter, 

 

what are the proper settings to get this waterfall filtering effect on other charts so i can continue to filter down. i hope i made sense

4 REPLIES 4
Helper IV
Helper IV

hello, enclosed is a screenshot. i am trying to create cascading filters, where is only shows relevant values in next chart, slicer but that i can continue to use those filtered values to continue filtering down to other tables or charts...  Not sure how to acomplish this.  Currently if I select a filtered chart, it removes all filters in report.  has anyone attempted this?  thanksmultiple filtering.jpg

You should Ctrl-select the second time, otherwise the first selection is being undone.

 

Community Support
Community Support

# Reply 1st

 

Hi@ ilcaa72 

You can try to add multiple slicer and set interaction in Edit interaction.

When you filter in 1st slicer ,other slicer will be filtered ,and then you filter in 2nd slicer ,the rest of slicer will be filtered again ……

1.png

 

 

Best Regards,

Lin

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

it doesnt work that way. you first filter shows everything selected,its your second filter that is filtering the table.  you should be able to select the first filter, which will filter the second filter (which has now limited selections)  then select a value in second filter to filter down the table.  

 

 

 

here is a visual example...

 

multiple filtering.jpg

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors