Forum Discussion

ReadTheIron's avatar
ReadTheIron
Icon for Helper III rankHelper III
5 years ago
Solved

Create selectable categories for numeric slicer

I'm trying to create a slicer that will sort numeric data into one of three categories that can be selected by radio button or checkbox: All 20+ 50+ My data currently looks something like this:...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi ReadTheIron ,

     

    I agreed with amitchandak 's suggestion—— You have to create an independent table using those three values. 

     

    And I have entered a table as shown below:

     

    Then please use the following formula to create a flag measure:

    Flag =
VAR _sum =
    CALCULATE (
        SUM ( 'Table'[Total Impact] ),
        ALLEXCEPT ( 'Table', 'Table'[Incident ID] )
    )
RETURN
    SWITCH (
        MAX ( 'ForSlicer'[Catrgory] ),
        "20+", IF ( _sum > 20, 1 ),
        "50+", IF ( _sum > 50, 1 ),
        "All", 1
    )

    Apply it to filter pane ,set as "is 1", the final output is shown below:

     

    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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

ReadTheIron , You have to create an independent table using those three values. You can use enter data

 

Then based on selected value you can return the measure

 

Switch(selectedvales(Bucket[Bucket]) ,

"All", sum(Table[Total Impact]),

"20+",calculate( sum(Table[Total Impact]), filter(Table,Table[Total Impact] >=20)) ,

"50+",calculate( sum(Table[Total Impact]), filter(Table,Table[Total Impact] >=50))

)

 

Try a measure like above