Forum Discussion

PowerBiNoob's avatar
PowerBiNoob
Frequent Visitor
9 years ago
Solved

Chart sort order per month

Hi,   I am busy with a couple of charts , the info need to be displayed needs to be per month , but a different kind of sort order is needed. currently there is (Jan,Feb,Mar..) or (Mar,Feb,Jan) , I...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    Try adding this column to your Date table and use the Sort By Column on your real month column to use this one.

     

    Month Sort Col = 0 - INT(FORMAT('Dates'[Date],"YYYYMM"))
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

PowerBiNoob

 

In this scenario, if you want to sort the months based on current month (current month on top). You could add a month sort column like below:

 

month sort = IF(MONTH('Table'[Date])-MONTH(NOW())<=0,MONTH(NOW())-MONTH('Table'[Date])+1,MONTH(NOW())-MONTH('Table'[Date])+13)

Then you can just sort the months based on above column.

 

 

Regards,