Horizontal Month name sort in Matrix

[heygowtam]

I Need to arrange the Month name in Order Because it is in the Financial Year Date Table July and August are not in Order in MATRIX Table.

 

is there any way to sort this out,

[danextian]

Hi @heygowtam ,

Have you tried sorting your months by another column?

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi-deskto... 

[Thennarasu_R]

You Need To created one Calculatd column

Column=format(Datecolumn,"yyyymm")

[heygowtam]

@danextian That works for normal Date Table not for Financial CalendarTable 

I found a solution, but it's not clear enough can you please please help with this 

https://community.powerbi.com/t5/Desktop/sort-horizontal-matrix-column-by-Fiscal-year-Month/m-p/5084...

[danextian]

Hi @heygowtam ,

The same solution should also work on other uses cases. I've had several data models that used Fiscal Year and the custom column sort worked perfectly. I would have something like below where YYYYMM is used as custom sort column.

[heygowtam]

@danextian I think it may work on all other graphs, I have used them as well. 

But, with the MatriX Visual I am not sure it works