Forum Discussion
Decomposition Tree Showing (Blank) Values Despite Data Filtering
Hi, You have two ways: Replace null values or take off null values:
1- Replace null values (i recomend): In Power Query, in your Product column replace empty values with any String you want:
1.
2. Replace null with any string you want:
Closse and apply, now you decomposition should look like this:
Note: Do the same for other columns.
2- Take Off Null values:
Now your decomposition should look like this, but note, taking off null values affect your sales amount value:
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!
Hello, I faced the same issue and I solved following this solution:
