Drilldown/sorting

[TrondEskild]

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? 

[Ritaf1983 · Accepted solution]

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

[TrondEskild]

Tat did the trick, thank you :).

[Ritaf1983]

Happy to help 🙂