Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!!
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.
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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,
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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português
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....,
Hi @luna_82,
I have some work related time constraints will look at this ASAP.
Sorry for the time.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi!
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
User | Count |
---|---|
88 | |
73 | |
69 | |
64 | |
56 |
User | Count |
---|---|
98 | |
92 | |
84 | |
74 | |
66 |