Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have encountered an issue where the Power BI Treemap does not show 0 value.
Category | Value |
A | 1.7% |
B | 0.32% |
C | 0 % |
The treemap is showing category A & B and not C. I need category C to show in the treemaps, as I am using this treemap for the user to filter other measures.
Please help.
Cheers,
Kev
Solved! Go to Solution.
Hi @BigKev
The Treemap won't work that way. As it displays parts compared to the whole, but 0 is 0, so you are looking to have 0 represented by some value in order to see it in the Treemap.
Maybe another visual is what you are after.
regards
Phil
Proud to be a Super User!
Hi @BigKev
The Treemap won't work that way. As it displays parts compared to the whole, but 0 is 0, so you are looking to have 0 represented by some value in order to see it in the Treemap.
Maybe another visual is what you are after.
regards
Phil
Proud to be a Super User!
@BigKev , Add +0 to you measure
or try like
divide([measure1], [measure2],0)
or
divide([measure1], [measure2],0)+0
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |