Slicer creates non-existent numeric range

[Belforen]

Hello, it is my first time consulting the community I hope you have a good day.

I have a numerical column called "RangeAnoWeekFormato", which contains the year concatenated the week (WEEKNUM) this week data does not exceed the number 53 in the year 2020

when implementing it in a slicer this generates a non-existent numeric string (red box)

there is the option only to display the data corresponding to the column

Greetings
my english is not good, i'm using a translator

[v-angzheng-msft · Accepted solution]

Hi, @Belforen 

It is a default behavior of range slicer especially when you choose Between. It will generate a continuous sequence of ranges between min date(numeric) and max date(numeric) of the column.

eg:

Even though non-existent sequence values are generated on the slicer, you still get the correct filtering results since there are no such values actually in your table.
If you don't want to see non-existent values on the slicer, then avoid using the between option or change the type of the field to a non-numeric type, it is worth noting that the between option cannot be used even after changing the type.
Although the slicer looks less than ideal it still gives correct filtering results, if you insist you can use the above mentioned approach.

Hope this helps.

refer:

Numeric Slicer showing values outside of dataset

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mussaenda]

Hi @Belforen ,

try going to your Data Model and then filter your column to 2021-00 so you can check why the result is like that.

[Belforen]

In the data model, this number range does not exist. Slicer generates it automatically