Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I am seeking help on how to sort a matrix visual on a calculated column. In the example shown I have a simple table and two matrix visuals. The top right simply places the table in a matrix. The lower right is a matrix of the monthly rank of product units. I would like to sort the lower right matrix by one of the months. How can this be done? Thanks in advance.
@MidtownMo , You need to have sort column and mark that as sort column
Month Year = FORMAT([Date],"mmm")
Month Year sort = month([DAte])
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Hi. I appreciate the quick response but it is not quite what I am looking for. I don't have month year or a date table, so it's not as easy as sorting by date. Instead, I'd like to be able to sort the matrix containing the rank on any month, preferably via a slicer. Thanks.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
55 | |
54 | |
37 | |
29 |
User | Count |
---|---|
77 | |
62 | |
45 | |
40 | |
40 |