Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Belforen
Frequent Visitor

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 week data does not exceed the number 53 in the year 2020

 

Belforen_0-1632833708385.png

 

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

 

Belforen_1-1632833859004.png

 

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

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

1 ACCEPTED SOLUTION
v-angzheng-msft
Community Support
Community Support

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:

vangzhengmsft_0-1633066367877.png

 

vangzhengmsft_1-1633066471149.png

vangzhengmsft_0-1633510934809.png

 

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.

View solution in original post

3 REPLIES 3
v-angzheng-msft
Community Support
Community Support

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:

vangzhengmsft_0-1633066367877.png

 

vangzhengmsft_1-1633066471149.png

vangzhengmsft_0-1633510934809.png

 

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
Super User
Super User

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.

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

Belforen_0-1632924662996.png

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.