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 want to use a YearWeek (201701 - 201752) column as a numeric range slicer.
Works fine, but it displays values > 201752. Values like 201753 - 201799 do not make sense in this use case.
I do know why these values are displayed (although they are not in the data), but I do not want them 🙂
Is there any possbility to 'hide' values that are not in the data/to 'hide' those NULL-values?
Cheers
I don't know why those numbers are included. Can you provide sample data or more details?
Hey @Greg_Deckler
I assumed those values appear because I formatted the column as whole number (to be able to use it in a numeric slicer).
Hi @SimonGrams,
A range slicer will display continual values. When you add a numeric field into it, it would show the min and max value as start and end point, then, any values between these two are available and selectable. Unfortunately, it is not able to change the default behaviour now.
Regards,
Yuliana Gu
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |