Forum Discussion
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
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,
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
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....,