Forum Discussion
Create a slicer to filter YTD % change
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.
- Anonymous4 years ago
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
1 Reply
- AnonymousNot applicable
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