Forum Discussion

TrondEskild's avatar
TrondEskild
New Member
3 years ago
Solved

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 a...
  • Ritaf1983's avatar
    3 years ago

    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