Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Sorting Matrix so that Months Show in Proper Order

Hi team! This is my first question, but I am having trouble sorting my matrix in PowerBI to show months in the correct order. Has anyone else solved this issue?   I need it to be: January, Fe...
Need Help
Show and Tell
Tips and Tricks
  • VIJAYKUMART's avatar
    VIJAYKUMART
    4 years ago

    1. add month id column in power query and close and apply

    2. do the following sort order 

     

    Hope this helps.

truptis's avatar
truptis
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous , Currently, it is getting sorted Alphabetically. You can click on your visual, see the 3 dots option on the top right, click on Sort Ascending and then select your month. Refer the screenshot below: 

Anonymous -> If this helps you, then pleas mark it as a solution & hit the thumbs up. Thanks.