Forum Discussion

tecumseh's avatar
tecumseh
Icon for Resolver III rankResolver III
2 years ago
Solved

Control Order Of Items In Slicer Drop Down

Hi all, How can I control the order of items in a slicer drop down? I entered numbers and index in a Table 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12  <- Values 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12...
Need Help
  • tecumseh's avatar
    tecumseh
    2 years ago

    Got it
    I typed in the list of values and the index
    I did not check the data types - both were text
    I converted both to whole numbers
    Now properly sorted
    Not sure why a list of numbers entered manually would be treated as text.
    Maybe best import absolutely everything is best policy?

     

    Thanks,

    -w

tecumseh's avatar
tecumseh
Icon for Resolver III rankResolver III
2 years ago

Got it
I typed in the list of values and the index
I did not check the data types - both were text
I converted both to whole numbers
Now properly sorted
Not sure why a list of numbers entered manually would be treated as text.
Maybe best import absolutely everything is best policy?

 

Thanks,

-w

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi tecumseh ,
    Thanks for your sharing.

    Best regards,
    Albert He