Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hello, i have a matrix setup with three row values and multiple value columns. How can i sort by two columns? I would like to sort the first row value in ASC order and the first value in ASC order.
Is this possible? I have tried converting into a table, sorting it, then converting back but this does not work.
Solved! Go to Solution.
Maybe the solution shown in this link will help you further:
https://www.biinsight.com/quick-tips-how-to-sort-matrix-by-column-in-descending-order/
Worth checking the following link:
https://community.powerbi.com/t5/Desktop/Matrix-multiple-Sort-columns/m-p/523938
@themistoklis the second value i would like to sortby is a date. I dont think the measure would work for that. What do you think?
Maybe the solution shown in this link will help you further:
https://www.biinsight.com/quick-tips-how-to-sort-matrix-by-column-in-descending-order/
| User | Count |
|---|---|
| 57 | |
| 43 | |
| 32 | |
| 16 | |
| 13 |
| User | Count |
|---|---|
| 84 | |
| 70 | |
| 38 | |
| 27 | |
| 24 |