Numeric range slicer - YearWeek

[SimonGrams]

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

[Greg_Deckler]

I don't know why those numbers are included. Can you provide sample data or more details?

[SimonGrams]

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).

SampleData

[v-yulgu-msft]

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