Forum Discussion
Cascading Slicers
Hi PaulDBrown ,
I've implemented exclude slicer selection with independent table logic. Could you please help me how to make that Slicer Cascading with other slicers?
Thanks in Advance.
5 Replies
Anonymous , In case you want to filter other slicer
use a measure from the common fact which joined to other slicers, that uses value of independent value and use that in visual level filter and filter for non blank
countrows(filter(Table, Table[column] in allselected(Ind[Column]) ) ) // check non blank in vsiaul level filter of slicers
Hi amitchandak - Thanks for the reply.
will it work if one table(exclude table i.e.copy of one dimension table) has no relation with fact table?
Hi amitchandak , Thanks for the reply.
Could you please little bit eloborate considering the following tables?
Dim[Column] , Fact[column_id] , Exl_selection[Column] and there is relationship between Dim[column_id] to Fact[Column_id].
Thanks in Advance.Hi Anonymous ，
Could you please provide some sample data from these tables(Dim, Fact, Exl_selection) and a screenshot of the final effect of the cascade slicer you want to implement (the slicer fields involved and the mechanism of operation)? Later on we can provide you with a suitable solution based on the information you share. Thank you.
Of course, you can also refer to the links mentioned in my previous reply to implement the cascade slicer functionality.Do's and Don't with cascading slicers in Power BI
INT, NOT EMPTY | Cascading slicers
Best Regards
Hi Anonymous ,
You can refer to the content in the following blogs and videos to create cascading slicers:
Do's and Don't with cascading slicers in Power BI
INT, NOT EMPTY | Cascading slicers
Best Regards
