Forum Discussion

jakseadog's avatar
jakseadog
New Member
5 years ago
Solved

Slicer to show values less or equal

Hello,   Here's my scenario:   In the Table I have column "A" with following values: 1,2,3,4. I added slicer from this column, so I'm able to select between 1,2,3,4. I want this slicer to filte...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi jakseadog ,

     

    Method1 : As Anonymous  said, just choose "Less than or equal to"  as the type for the slicer:

     

    Method2:

    • Create a new table for slicer 

    • Apply the following measure to filter pane like this:
    Measure = IF(MAX('Table'[A])<=MAX('ForSlicer'[A]),1,0)

     

    Best Regards,
    Eyelyn Qin
    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 jakseadog ,

 

Method1 : As Anonymous  said, just choose "Less than or equal to"  as the type for the slicer:

 

Method2:

  • Create a new table for slicer 

  • Apply the following measure to filter pane like this:
Measure = IF(MAX('Table'[A])<=MAX('ForSlicer'[A]),1,0)

 

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