Forum Discussion

SimonGrams's avatar
SimonGrams
Helper I
7 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
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

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

  • SimonGrams's avatar
    SimonGrams
    Helper I
    7 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
      Microsoft Employee
      7 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