How to sort axis based on month in power bi

[Anonymous]

Hi All,

I had problem when i am sorting the axis. In my report the x-axis is shown as (period_name) JAN-09,FEB-10....etc 

for this i had a column as Jan-09,feb-09..........dec-09 and Jan-10,feb-10.......dec-10 . i also had additional column for the( period_num ) as 1,2,3,4........12. when i am trying to sorting the month based on month number i am getting the followign error. 

Need help to sort this...Thanks in advance

Thanks & regards,

Prabhu

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can refer to the following the link to create a custom sort table to set sort order of your table field:

Custom Sorting in Power BI  

Regards,

Xiaoxin Sheng

[amitchandak]

Your sort column should have a format like YYYYMM

sort month = format(date,"YYYYMM")

This one should work fine.

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601