Forum Discussion
Numeric Range Slicer not showing correct values
Good day!
Sorry for the late reply, I was at a conference and didn't have a chance to answer this question.
I am getting the results in the first set of pictures, where the Slicer that shows the min and max values as -241 and 207 for the submission period of 2023Q1.
First, I want to see is the Slicer that shows the min and max values as -6 and 49.
Second, a formula that gives me the percentage of the records between the slicer min and max values.
For example, if there are 800 records in the entire dataset in 2023Q1 and 400 of them are between -6 and 49 (including -6 and 49), the percentage should be 50%. If I slide the slicer to values 0 and 7 and let's say there are 100 records between those values, the percentage should be 12.5% of the total records (in 2023Q1) are between 0 and 7.
Thanks!