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.
Hi
I have a numerical slicer for which Im using the "Between" option. The dataset for the slicer is a year & month code in the format of YYYYMM. For example... 201801, 201802, 201803 etc.
What I am seeing is the slicer is "filling in" numbers between the min and max of the dataset. I am seeing YYYYMM values in my slicer such as 201745, 201746 etc. This is causing my bar graphs on the same page as the slicer to have axis points for each of these non month periods even though they do not exist in my dataset.
Is there a way to force the slicer to only show the values within the data set or is this by design?
See below for example.
Any help would be greatly appreciated.
Solved! Go to Solution.
It is a default behavior of range slicer especially when you choose Between. It will generate dates between min date and max date of the column if you use the date column.
It is a default behavior of range slicer especially when you choose Between. It will generate dates between min date and max date of the column if you use the date column.
It is not true
Thanks Savi. I expected that would be the case.
Appreciate the feedback.
Regards
It's a pleasure:)
Thanks,
Siva
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 |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |