Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |