This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 31 | |
| 24 | |
| 23 | |
| 20 | |
| 16 |
| User | Count |
|---|---|
| 63 | |
| 38 | |
| 28 | |
| 23 | |
| 22 |