Forum Discussion

sylwestercz's avatar
sylwestercz
Helper I
8 years ago
Solved

Parent-Child Hierarchy - sorting issue

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.

 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      sylwestercz
      Helper I
      8 years ago

      Hi Lydia Anonymous

       

      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...

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        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

  • sarath_chandra's avatar
    sarath_chandra
    Helper III
    3 years ago

    Anonymous , sylwestercz 

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

    input file structure

    output requirement

    Anonymous  please help me out with your solution