Forum Discussion
Drilldown/sorting
Hi, I have a table wich consist of a hierarki with 3 different levels. Power bi sees to sort out the amounts for level 1 and 3 but not level 2. When I expand/drill down from level 1 the same amount appears on level 2. But when I expand/drilldown from level 2 to 3, sorting is correct. Any hints or tips?
Hi TrondEskild
Generally, you need to have in your data table sort columns for every level of your hierarchy and modify its sort order.
For example, in my generated table I have category level and measure level so they have to be sorted like in the attached pictures :
To give you a more detailed solution please provide some sample file
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
3 Replies
Hi TrondEskild
Generally, you need to have in your data table sort columns for every level of your hierarchy and modify its sort order.
For example, in my generated table I have category level and measure level so they have to be sorted like in the attached pictures :
To give you a more detailed solution please provide some sample file
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Tat did the trick, thank you :).
Happy to help 🙂
