cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
luna_82 Frequent Visitor
Frequent Visitor

hierarchy levels

Hi!

 

it's possible to have diferent levels of hierarchy in the same Matrix for diferent rows?.

 

For example, i have 4 levels , L1, L2, L3, L4 but not all the levels have all.

 

 

L1

  L2  <- this have 4 levels

     L3

       L4

 L2  <- this one have only 3 levels

    L3

 L2  <- this have only 2 levels

 

 

i think that it's not possible to achieve but maybe you know how to do that

Thank you for your help!! 

9 REPLIES 9
luna_82 Frequent Visitor
Frequent Visitor

Levels and hierarchy

Hi!

 

it's possible to show diferent levels of hierachy in the same matrix for diferent levels of nesting?

 

like this, i have 5 levels but only the L4.1 have all the levels the other only hace 2 or 3 ...

L1

   L2.1

      L3

      L4

         L4.1

             L5.1.1

             L5.1.1

        L 4.2

   L2.2

      L3

 

Thank you

Super User
Super User

Re: hierarchy levels

Hi @luna_82,

 

Yes this is possible depend on the setup you have on your information.

 

I had a similar setup needed and added the different aggegator row considering the diferences between several levels.

 

Can you share a sample of the data and expected result?

 

Regards,

MFelix

 

 



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

Proud to be a Datanaut!




v-xjiin-msft Super Contributor
Super Contributor

Re: hierarchy levels

Hi @luna_82,

 

It is able to achieve your requirement. Please refer to following sample:

 

1.PNG

 

Reference: https://www.youtube.com/watch?v=q8WDUAiTGeU 

 

Thanks,
Xi Jin.

luna_82 Frequent Visitor
Frequent Visitor

Re: hierarchy levels

Hi @MFelix

 

My data is 

0NULLCAPEXGNULL
10CRNULL
108AN090010025
118SNER090010080
128RE090010035
136DEM090010040
146EMT010060022
156EMR090010062
16NULLCAPEX NGNULL
1716IS030010010
1816IE030020060
1916IS030020050
21ERO090010015
31AP090010010
40MNULL
54DR090010050
64SYCNULL
76C010060030
86MRNULL
98F090010030
NULLNULLNULLNULL

 

and the result is like this 

 Caso2.png

 

PowerBI always show all the levels. Is i filter by level3 != blank the group CAPEX NG disappear....

 

Thanks a lot for your help!!

Super User
Super User

Re: hierarchy levels

Hi @luna_82,

 

Not reaaly sure how you make the link between CAPEX NG and CAPEX G and the other level,  is it based on what column?

 

Regards,

MFelix



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

Proud to be a Datanaut!




luna_82 Frequent Visitor
Frequent Visitor

Re: hierarchy levels

 

CAPEXG and CAPEXNG are parents . 

 

Sorry because the column header is crop. The first column  is Id, next ParentId, description, and the last one is a code. 

 The expected result will be something like that , the green are the leaf nodes....,

 

Screenshot_2.png

Super User
Super User

Re: hierarchy levels

Hi @luna_82,

 

I have some work related time constraints will look at this ASAP.

 

Sorry for the time.

 

Regards,

MFelix



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

Proud to be a Datanaut!




luna_82 Frequent Visitor
Frequent Visitor

Re: hierarchy levels

thank you @MFelix !!!

Super User
Super User

Re: hierarchy levels

Hi @luna_82,

 

Although I have send you the solution by private message last month I was only abble to provide the soluiton here now.

 

I refered to this article from @marcorusso, in this article the hierarchy are calculated based on the path that each hierarchy level has then based on that we do a lookup of the previous level.

 

The several levels of hierarchy are calculated in hidden columns then we use to make the final calculations based on the measure we need.

 

Check the article in detail and the PBIX file attach with the solution.

 

Regards,

MFelix



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

Proud to be a Datanaut!




Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 155 members 2,224 guests
Please welcome our newest community members: