Forum Discussion
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
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
Hi MFelix
My data is
0 NULL CAPEXG NULL 1 0 CR NULL 10 8 AN 090010025 11 8 SNER 090010080 12 8 RE 090010035 13 6 DEM 090010040 14 6 EMT 010060022 15 6 EMR 090010062 16 NULL CAPEX NG NULL 17 16 IS 030010010 18 16 IE 030020060 19 16 IS 030020050 2 1 ERO 090010015 3 1 AP 090010010 4 0 M NULL 5 4 DR 090010050 6 4 SYC NULL 7 6 C 010060030 8 6 MR NULL 9 8 F 090010030 NULL NULL NULL NULL and the result is like this
PowerBI always show all the levels. Is i filter by level3 != blank the group CAPEX NG disappear....
Thanks a lot for your help!!
Hi luna_82,
It is able to achieve your requirement. Please refer to following sample:
Reference: https://www.youtube.com/watch?v=q8WDUAiTGeU
Thanks,
Xi Jin.
