Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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
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
thanks @v-yuezhe-msft this is eactly what I was looking for. (and your desciption helped me find it @ajmonster )
Use the filters area, Advanced to set this up.
@Greg_Deckler I don't want to use the page level/drillthrough/report level filters. I want this to be in a slicer.
The only filter that works like that is the Date filter. You may be able to find a custom visual slicer that does this.