Forum Discussion

SimonGrams's avatar
SimonGrams
Icon for Helper I rankHelper I
8 years ago

Numeric range slicer - YearWeek

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. ...
Need Help
SimonGrams's avatar
SimonGrams
Icon for Helper I rankHelper I
8 years ago

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's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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