Forum Discussion

nrustamli's avatar
nrustamli
Frequent Visitor
5 years ago
Solved

Multiple slicers for one visual

Hello there. I am trying to apply two separate sliders for one visual. The data I am working on has the following structure: Countries Year Variable 1 Variable 2 Variable 3 Austria 2018 ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi nrustamli ,

     

    The file is here, you can check if it is what you want.

    Because I don’t know your needs, so the value shown in my picture is Variable 1.

    Measure = 
CALCULATE (
    SUM ( 'Table'[Variable 1] ),
    FILTER ( 'Table', [Countries] = SELECTEDVALUE ( Slicer1[Countries] ) )
)
    Measure 2=
CALCULATE (
    SUM ( 'Table'[Variable 1] ),
    FILTER ( 'Table', [Countries] = SELECTEDVALUE ( Slicer2[Countries] ) )
)
    Measure 3 = IF(ISFILTERED(Slicer2[Countries]),[Measure])
    Measure 4 = IF(ISFILTERED(Slicer1[Countries]),[Measure 2])

     

     

     

    Best Regards,

    Stephen Tao

     

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

nvprasad's avatar
nvprasad
Solution Sage
5 years ago

Hi,

 

You can use the edit interactions option under the format tab (Select slicer first then go to format tab) to fix this issue.

 

 

 

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad

  • nrustamli's avatar
    nrustamli
    Frequent Visitor
    5 years ago

    Hello, could you please elaborate on this? Because my first thought was about the interactions as well, here how the interactions of Slicer 1 look:

    And here are the interactions of Slicer 2:

    Anything else that needs to be done here?