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.

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

Thanks for the response, amitchandak ! I'm still quite new to Power BI so I'm having some trouble figuring out the last step. I've created the measure, then created a slicer with Buckets[Buckets] as the selected data field. It looks just like what I need!

 

However, when I make a selection, the graphics on the page don't change. They will change based on the slider based on the Impact field. Is there another connection I need to be making?