Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |