Turn Discrete List into Continuous Filter

[ajmonster]

Hello

I have a discrete list of completion percentages that I would like to use to slice my data so I can answer questions like, "What is the record count for less than (or greater than) x% completion?"

I would like this filter to be similar to a Between/After/Before Slicer for a date column (continuous).

Thanks,

ajmonster

[v-yuezhe-msft · Accepted solution]

@ajmonster,

What is the data type of your percentage field? If it is numeric field, you can use "Less than or equal to" or "Greater than or equal to" options in the slicer.



Regards,
Lydia

[KarenStewart]

thanks @v-yuezhe-msft  this is eactly what I was looking for. (and your desciption helped me find it @ajmonster )

[Greg_Deckler]

Use the filters area, Advanced to set this up.

[ajmonster]

@Greg_Deckler I don't want to use the page level/drillthrough/report level filters. I want this to be in a slicer.

[Greg_Deckler]

The only filter that works like that is the Date filter. You may be able to find a custom visual slicer that does this.