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.

 

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

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    8 years ago

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

    • 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