Parent-Child Hierarchy - sorting issue

[sylwestercz]

Hi All,

I hope you can put some light into my problem. 

I have a Profit&Loss with Parent-Child hierarchy with 4 levels and everything works fine except one tiny detail. When I have all my data in the matrix, expanded all the way down all the account names are in the alphabetical order instead of the order I want them to be (see dummy example below).

In my Parent-Child hierarchy with all the DAX codes etc, I have an index column, and tried to sort the Child columns by that index however it does not work. 

I wonder if anyone had similar issue? Any help will be highly appreciated. Thank you.

[sarath_chandra]

@v-yuezhe-msft , @sylwestercz 

can you please let me this task possible in power bi or not

input file structure

output requirement

@v-yuezhe-msft  please help me out with your solution

[v-yuezhe-msft]

@sylwestercz,

How do you store these data in your table? Could you please post the structure of your table with the Index column? And also please post the error message you get when sorting columns.

Regards,
Lydia

[sylwestercz]

Hi Lydia @v-yuezhe-msft

Please see below how my hierarchy looks like. 

In the Matrix visual I put Hierarchy (Level1 & Level2 & Level3 & Level4) as Rows and a measure as Values. The thing is that all hierarchy levels are presented alphabetically and I would like to find a way to make their appeareance in the Matrix as per AccountKey. 

If instead of Hierarchy I put just AccountName in Rows, then everything is listed as per AccountKey however then I do not have the Parent-Child hierarchy, just the lowest level Account with corresponding value. In other words, Contribution Margin, Primary Costs, Salary, Other Costs are not presented in the Matrix. 

The more I look into this the more I get the feeling it will not be possible...

[v-yuezhe-msft · Accepted solution]

@sylwestercz，

I am afraid that it is not possible to sort the level4. A workaround is to add number(1,2,3) before these values as below.



Regards,
Lydia

[sylwestercz]

@v-yuezhe-msft

And that is exactly what I did now for Level 3 and will to the same for Level 4, perhaps with letters like a) b) c) .... but that requires changing (or adding lookup column) in the main source with all AccountName(s) so the relationship will follow along the chain. 

Hopefully this will be recognized by Microsoft and (if there is a way) fixed or improved in the future. 

Thank you Lydia!

Have a great day and Merry Christmas! 

Sylwester