Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
In a matrix view, i used a measure in values for a report. In the report if i sort the report by this measure, this doesnot work. Pls help.
Hi @bprakash,
In a Matrix, we can only change the order in row level.
Besides, when we sort the matrix by measure, the order is determined according to Total values rather than detailed records per column per row.
Regards,
Yuliana Gu
Hi @bprakash,
Currently, it is not achievable.
Regards,
Yuliana Gu
@Anonymous said "There is no way of sorting a matrix visual by a column not being displayed."
I found a way to not display my sort value because the the table in my matrix has a fixed number of lines. So I simply shrank the visual height to cause the bottom line to always be off the visual and thus it is sorted and not displayed. The only hangup is there is a vertical scroll bar on the far right that is always displayed.Sorted Columns
Hidden Sort Value
I really like Power BI, but it seems that on such important items it still lags behind Tableau. This sorting issue while very important should be trivial in how it's done. I have tried all kinds of approaches and still there is no way of sorting a Matrix visual by a column not being displayed.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
79 | |
63 | |
52 | |
47 |
User | Count |
---|---|
217 | |
89 | |
76 | |
66 | |
60 |