Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Grouped numeric slicer

I have a table of values in my source that shows properties, including data such as property name, locaiton, square foot, etc.

 

I want to create a filter on my dashboard that links to the 'square foot' column, but instead of showing a numeric slicer where you can drag the controls I want a drop-down that shows the following ranges:

 

  • 0-1000
  • 1000-5000
  • 5000-10,000

 

Is this possible to do? Any help would be much appreciated.

 

Thanks

Need Help
Show and Tell
Tips and Tricks
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi Anonymous 

    Followed the articles shared by amitchandak,

    Create a table

    Create a measure

    Measure = CALCULATE(SUM('Table'[value]),FILTER('Table','Table'[value]>=SELECTEDVALUE(range[min])&&'Table'[value]<=SELECTEDVALUE(range[max])))

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies