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.

Anonymous's avatar
Anonymous
Not applicable
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.

  • nrustamli's avatar
    nrustamli
    Frequent Visitor
    5 years ago

    Thanks a lot Stephen, this indeed solves it!

  • hereskieu's avatar
    hereskieu
    New Member
    2 years ago

    Hi Stephen, 

     

    I have the similar project like nrustamli that I want to apply two slicers(filters) for one visual.  I tried to follow your measures but it ran into an issues.  It keeps telling me that 'Cannot find table 'Slicer1'.  Can you help me on how to fix it? 

     

    TIA,

    Kieu