Decomposition Tree Showing (Blank) Values Despite Data Filtering

Hello Bibiano_Geraldo,

Thank you for your detailed response and the step-by-step images — I really appreciate it!

Unfortunately, applying your methods to my dataset causes me to lose crucial data. My goal is to create a hierarchical visualization that includes all data, with null or empty fields representing "leaf nodes" that should not be filtered out.

The issue is that the Decomposition Tree seems to treat these nulls as values to eliminate or replace, but they are a valid part of my hierarchy, marking the end of a branch. I’ve read that the Decomposition Tree is more suited for metric analysis, which may explain the challenge.

Do you have any other suggestions for representing this kind of hierarchy? I’ve also found that most native Power BI visuals or marketplace alternatives either don't work well for my needs or require paid options.

Thanks again for your help — any further ideas would be greatly appreciated!