Cascading Slicers

[Anonymous]

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.

[Anonymous]

Hi @Anonymous ,

You can refer to the content in the following blogs and videos to create cascading slicers:

Power BI – Cascading Slicers

Do's and Don't with cascading slicers in Power BI

INT, NOT EMPTY | Cascading slicers

Best Regards

[amitchandak]

@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 

[Anonymous]

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.

[Anonymous]

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.

Power BI – Cascading Slicers

Do's and Don't with cascading slicers in Power BI

INT, NOT EMPTY | Cascading slicers

Best Regards

[Anonymous]

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?