Forum Discussion
Sort the Matrix Table Order in Power BI
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...
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.
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
amitchandak I have done that column sort too. Then also no changes.
Anonymous ,Can you share a sample pbix after removing sensitive data.
amitchandak Please find the PBIX file in the below location.