Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

    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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      Anonymous
      Not applicable
      4 years ago

      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