Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |