Forum Discussion

caito103's avatar
caito103
Icon for Helper I rankHelper I
8 years ago
Solved

Sorting by Month name using month number doesnt work

Hello!   I need hel from you guys. I actually searched abput sort correctly by Month name, creating a Month nummber column and sort the column Month name by Month number, but didt work.     ...
Need Help
  • dramus's avatar
    dramus
    8 years ago

    MesNum is defined as Text. Switch it to Whole Number and that will fix the sort.

dramus's avatar
dramus
Icon for Continued Contributor rankContinued Contributor
8 years ago

I can't reproduce the problem you are having with a demo dataset. Can you share your .PBIX file with me?

caito103's avatar
caito103
Icon for Helper I rankHelper I
8 years ago

Of course! There you go.

 

https://ufile.io/ovfpu

 

Can be that the month order have problem because there are two years with differents months? (2017 have from June until December, and 2018 just have January/February)

 

Thank you so much!

  • dramus's avatar
    dramus
    Icon for Continued Contributor rankContinued Contributor
    8 years ago

    MesNum is defined as Text. Switch it to Whole Number and that will fix the sort.

    • caito103's avatar
      caito103
      Icon for Helper I rankHelper I
      8 years ago

      Oh man! Was so simple! With it takes a lot haha, thank you so much!!!