Data Science Wire

Remove Blank elementa in Decomposition Tree

Reddit r/PowerBI1mo4 min read

Hi experts! I'm trying to visualize a hierarchy using the decomposition tree visual in Power BI, which I think is a great fit for this use case. I've flattened out the hierarchy so that each level of the hierarchy has its own column. Level_1 Level_2 Level_3 Level_4 Level_5 Level_6 Level_7 X X1 X11 BLANK BLANK BLANK BLANK X X1 X12 X123 BLANK BLANK BLANK Y Y1 Y11 Y111 Y1111 Y11111 Y11111 The problem: some levels contain blank values, and these blanks are still being rendered as their own boxes/nodes in the decomposition tree. I've tried using the visual-level filter, but that filters out the ent

Read the full story at Reddit r/PowerBI

More in Analytics Engineering