Forum Discussion

Belforen's avatar
Belforen
Frequent Visitor
4 years ago
Solved

Slicer creates non-existent numeric range

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 w...
  • v-angzheng-msft's avatar
    4 years ago

    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.