Forum Discussion

ale-hd's avatar
ale-hd
Helper I
4 years ago
Solved

Create a Hierarchy from elements on the same columns

Hi All, hope all the best for you all.

I could share the .pbix file for this case but I don't know how! I will do it with please if anybody explains me how. Looking at it would probably more effective than my description.

 

Anyway simple starting point: 2 tables, 1st is Sales, 2nd is Channels (where the sales are from).

Looking at the matrix at the bottom below, you will see the Channels as columns headers, but this result is wrong.

The problem is in the "Channels" table:

channels are all in the same columb but actualli they are from different levels: i.e. level 1 is Web, sublevels are "Direct", "Campaign" and each of this sublevel can have as many subsequent sublevels as you like.

The problem is that the software generates all the leveles in the same table. As you can see in the image they are all listed together with the field "Level" that indicates the level.

In this specific case the operators created up to the 3 level, but the number of level can change depending on the single client. 

 

The question is: How can I create a Hierarchy on the Channels? 

Thank  you very much!

 

 

4 Replies

  • ale-hd Have you tried creating a PATH column from your Channels table columns?

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support

    Hi  ale-hd ,

     

    Would you pls provide some sample data for test?

     

    Remember to remove the confidential information.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

    • ale-hd's avatar
      ale-hd
      Helper I

      Hello Kelly, I have a pbix file created as example to share it, but I do not know how to do it...

      Thank you.