Showing 0% value in Tree map

[BigKev]

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

[PhilipTreacy · Accepted 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

[amitchandak]

@BigKev , Add +0 to you measure

or try like 

divide([measure1], [measure2],0)

or

divide([measure1], [measure2],0)+0