Create a slicer to filter YTD % change

[nbs33]

Hi,

I have a requirment to filter a report by the change in YTD sales.

For example I have a table with customers and their % change in YTD sales vs the previous year. I would like to be able filter this table by 10% incriments.  So there would be a slicer with selections for "100- 90%", "90-80%", "80-70%", etc....

I have searched everywhere and have been unable to find a solution. I created a measure to group customers by these 10% increments but I can use this as a slicer. 

Any ideas on how to achive this are greatly apprciated. 

[Anonymous · Accepted solution]

HI @nbs33,

According to your description, it sounds like a common segmentation filter requirement based on measure expression. If that is the case, I'd like to suggest you take a look at the following links if they help:

Dynamic segmentation – DAX Patterns

Static segmentation – DAX Patterns

Regards,

Xiaoxin Sheng