I created a year hierarchy to be used in a slicer/filter (as shown below)
However, when i put the "Month" into the slicer, it sorts in alphabetical order instead of from Jan-Dec (as shown below)
How can i solve this issue?
I created a year hierarchy to be used in a slicer/filter (as shown below)
However, when i put the "Month" into the slicer, it sorts in alphabetical order instead of from Jan-Dec (as shown below)
How can i solve this issue?
Copyright © 2021 Jogjafile Inc.
You need to create a new column in your Date table. Something like:
Then select your Month column, under
Column tools
tab in the ribbon, selectSort by column
and select the new column you just created (MonthNum
).