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.