Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Relational Slicers

Hi guys,

In my report i have some slicers. Requirment is that when i select any value in one slicer, then all other slicers having related data to selection should get afested and display their data.

Explained with Screenshots below: Empty all

On selecting a value in mgmt lvl 5

 

Need Help

10 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi Anonymous 

    If the slicers are coming from the same dimension then it should happen by default, if that's not the case then you can create a measure like 

    filter = INT( NOT ISEMPTY( 'fact table' ) )

    and use it as a visual filter where the condition is = 1 

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    Mariusz Repczynski

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Mariusz  let me know what do you mean by same dimension here?

      • Mariusz's avatar
        Mariusz
        Community Champion
        6 years ago

        Hi Anonymous 

         

        Columns coming from the same Table ( Dimension ), basically a lookup table with attributes for example ( city, state, country ) that is used to filter transaction table ( Facts ).

         

        Best Regards,
        Mariusz

        If this post helps, then please consider Accepting it as the solution.

        Please feel free to connect with me.
        Mariusz Repczynski