Forum Discussion
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 ...
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.
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.
Thanks a lot Stephen, this indeed solves it!