Grouped numeric slicer

[shaunmag]

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

[v-juanli-msft · Accepted solution]

Hi @shaunmag 

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.

[amitchandak]

@shaunmag , refer if these can help

https://www.daxpatterns.com/static-segmentation/

https://www.daxpatterns.com/dynamic-segmentation/