Forum Discussion
order a matrix
Hi Anonymous ,
As a workaround, you can try using a Table visual instead of a Matrix. The Table visual allows flexible sorting by any column, including values like revenue or specific months ,which can help achieve the sorting behavior you're looking for.
Hope this helps !If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
If you continue to face issues, feel free to reach out to us for further assistance!
Hi Anonymous ,
Thanks for reaching to Microsoft Fabric Community Forum.
- To display and sort monthly rolling revenue in a matrix visual, we used a DateTable with a YearMonth column (e.g., "Jan 2024") and sorted it using a numeric YearMonthNum column (e.g., 202401). This ensured chronological sorting of columns.
- A DAX measure calculated the revenue over the last 12 months using DATESINPERIOD, allowing the matrix to show clients in rows and rolling months in columns with correct totals and order.
I am sharing the sample data file for better understanding with expected output :
If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Thanks for using Microsoft Fabric Community Forum.
Thanks, that's what I did, but how can I sort the revenue by client for January 2024? I'd like client B to appear on the first row, for example. Actually, I want to be able to sort the revenue by client for each column in my matrix (by month). Normally, it's not possible to do that, and I'm trying to find an alternative.
Hi Anonymous ,
for the above queries :- To ensure that Client B appears in the first row of your matrix, you can create a custom sorting column in your data model. Here’s how you can do it:
2. Yes,Power BI's Matrix visual does not natively support sorting rows on a per-column basis (i.e., sorting by month).
If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
If you continue to face issues, feel free to reach out to us for further assistance!
Hi Anonymous,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.If the response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.
Thank You.
Hi Anonymous ,
If the information is helpful, please accept the answer by clicking the "Upvote" and "Accept Answer" on the post. If you are still facing any issue, please let us know in the comments. We are glad to help you.
We value your feedback, and it will help us to assist others who might have a similar query. Thank you for your contribution in enhancing Microsoft Fabric Community Forum.
Is there no other solution (a workaround) to sort the months in ascending/descending order?
Hi Anonymous ,
As a workaround, you can try using a Table visual instead of a Matrix. The Table visual allows flexible sorting by any column, including values like revenue or specific months ,which can help achieve the sorting behavior you're looking for.
Hope this helps !If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.
If you continue to face issues, feel free to reach out to us for further assistance!