Sort the Matrix Table Order in Power BI

[Anonymous]

I have the below matrix table visual. 

Rows comes from a Column1 in a Table1

Values comes from a Measure1 in Table1

Columns comes from a Date coulumn in a Calender Table

Now I need to sort my rows and columns.

My columns need to be Jan, Feb and Mar. Now it is not sorted. 

My rows should be Brought Forward, Raised, Closed and Carried Forwared. Now it is not sorted.

Please help.

[amitchandak]

@Anonymous , Make sure you have sort column for month year

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")

Mark month year sort as sort column for the month year

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[Anonymous]

@amitchandak I have done that column sort too. Then also no changes.

[amitchandak]

@Anonymous ,Can you share a sample pbix after removing sensitive data.

[Anonymous]

@amitchandak  Please find the PBIX file in the below location.

https://1drv.ms/u/s!Ah-kO6CqeTNOgja6Dl7VXunGkYjK?e=XOckdh

[Icey · Accepted solution]

Hi @Anonymous ,

It is needed to sort by the order columns like so:

Then you can get this:

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.