Forum Discussion

nbs33's avatar
nbs33
Helper II
4 years ago
Solved

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.