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!
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.
Hi Anonymous ,
Just checking in, We wanted to follow up on your question regarding sorting the matrix columns by rolling months in Power BI Report Server.
If you’ve found a solution that worked, we’d appreciate it if you could mark the response as "Accepted" and upvote it. This helps other users with similar issues find the solution more easily.
If you're still facing the issue or need further clarification, feel free to add a comment we’re happy to assist further.
Thanks again for being part of the Microsoft Fabric Community and helping make it a more valuable space for everyone!
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!