Forum Discussion
Different Sort Criteria on different Levels in a Table
Hi guys,
i have the following problem.
I have a table, where I would like to give our sales guys a drill down functionality.
They can analyze margins for specific articles and on the next level they can see the lot sizes.
I would like to have the lot sizes not to be sorted by sales, but based on their actuals order, I have used the "sort by" functionality to sort the lot sizes in the correct way.
If I sort the data based on the first column, the order is also correct for the lot sizes
Finally I want to have the relevant dimensions on top (sorted by sales), but the next level should be sorted differently, just like in
Pivot Tables in Excel, where you can sort the different levels on different criteria:
How can I do that on Power BI Desktop?
Here is some Sample Data
| ArticleGroup | Dimension | Lotsize | Order | Sales |
| ABS UNI | 300x1 | < 1.000 | 1 | 1.532 |
| ABS UNI | 300x1 | >= 2.000 | 2 | 2.422 |
| ABS UNI | 300x1 | >= 5.000 | 3 | 2.097 |
| ABS UNI | 300x1 | >= 10.000 | 4 | 7.053 |
| ABS UNI | 300x1 | < 1.000 | 1 | 16.788 |
| ABS UNI | 300x1 | >= 2.000 | 2 | 18.178 |
| ABS UNI | 300x1 | >= 5.000 | 3 | 19.696 |
| ABS UNI | 300x1 | >= 10.000 | 4 | 7.050 |
| ABS UNI | 300x1 | < 1.000 | 1 | 11.031 |
| ABS UNI | 300x1 | >= 2.000 | 2 | 8.614 |
| ABS UNI | 300x1 | >= 5.000 | 3 | 19.250 |
| ABS UNI | 300x1 | >= 20.000 | 5 | 12.348 |
| ABS UNI | 300x1 | >= 50.000 | 6 | 7.361 |
| ABS UNI | 300x2 | < 1.000 | 1 | 12.643 |
| ABS UNI | 300x2 | >= 2.000 | 2 | 152 |
| ABS UNI | 20x2 | >= 5.000 | 3 | 9.112 |
| ABS UNI | 300x2 | >= 10.000 | 4 | 10.400 |
| ABS UNI | 300x2 | < 1.000 | 1 | 2.373 |
| ABS UNI | 23x2 | >= 2.000 | 2 | 5.677 |
| ABS UNI | 300x2 | >= 5.000 | 3 | 7.539 |
| ABS UNI | 300x2 | >= 10.000 | 4 | 4.006 |
| ABS UNI | 300x2 | < 1.000 | 1 | 18.369 |
| ABS UNI | 300x2 | >= 2.000 | 2 | 19.347 |
| ABS UNI | 300x2 | >= 5.000 | 3 | 10.256 |
| ABS UNI | 300x2 | >= 20.000 | 5 | 2.941 |
| ABS UNI | 300x2 | >= 50.000 | 6 | 12.422 |
@JensMarkgraf , In Power bi Matrix classification is not yet allowed. Therefore, if sorted in value(measure) the row (column/dimes) will align with that. Or if sorted in the row, the rest of the row member will take that guy
3 Replies
- amitchandak
Super User
@JensMarkgraf , In Power bi Matrix classification is not yet allowed. Therefore, if sorted in value(measure) the row (column/dimes) will align with that. Or if sorted in the row, the rest of the row member will take that guy