Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Parent and child loop

Hi, 

I need some help on this requiremt I have a data like parent and child like below, here I need to create parent child hierarchy in matrix visual in the form expand and cllapse feature. below the sample data for example.

Here I need to take a value 'A' from Child column and filters in parent column I get the data like this.

The child values D,C,B,A those values returns in separate column that is level1. this step we need handle it from the dax query and create a new column that is level1. next the 'D' value from Child column and filters in parent column I get the data like this.

The child values H,G,F those values returns in separate column that is level2. this step also we need handle it from the dax query and create a new column that is level2.

 

Then those level1 and level 2 columns I need show in the matrix visual in the form expand and collapse feature.

 

I tried this 7in many ways but I did not find the solution yet.

 

Can someone please help me onthis that really a great.

 

Thanks.

 

 

 

Need Help

3 Replies

  • TheoC's avatar
    TheoC
    Community Champion
    2 years ago

    Hi Anonymous 

     

    Hope you're doing well.

     

    I am hoping I have understood your requirement correctly and you wanted the child levels concatenated.  The output effectively is two new columns being Level 1 and Level 2 which can then be used as you require for the Level filtering.

     

     

    Please see attached PBIX file and let me know if this is what you are after?

     

    Thanks heaps,

    Theo

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi, Thanks for sharing your inpputs on this.

      In level all the child data for "A" you are showing side by side with the help of "," as a delimiter. but I am expecting those values in row by row like below. so is there any possibility to handle this.

      Child   Level

      A         A

      A         B

      A         C

      A         D

      Then I will use level 1 column in matrix table with hierarchy

      +A

         +A

           +B

              +C

                 +D like this

      If I cliclk +B then 

      +C

        +D 

           +E

              +F     like that.

      Is there any possibily please help me on this I was really struggling this to fulfil the hierarchy.

       

      I can't see the option to share the PBIX file other wise I will show with some dummy data and share the pbix file with you for better understanding.

       

      Thanks.

      • TheoC's avatar
        TheoC
        Community Champion
        2 years ago

        Hi Anonymous 

         

        Thanks for letting me know.

         

        Please see attached.  The output should align to what you've described! Hope this helps 🙂