Forum Discussion
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...
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"))
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"))