displaying negative values in Treemap

[Anonymous]

Hi All,

I have a requirement where I need to show top 5 and bottom 5 values basen on measures for different countries and I am using treemap as a visualization. But I have to display negative values as well in the graph and treemap has a limitation where it can’t display the negative values.

Is there a way around for this? if not please suggest a better visualization to showcase the data.

Thanks in advance,

Rakesh

[dax · Accepted solution]

Hi rakeshreddyp, 

You could try to measure to show negative  value,  or you could use abs() function to change negative value and use conditional formatting to show it. You could referto my sample.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mircogia]

hi CST,

when i look at my treemap the "i" says "negative values aren't supporte and are being deslayed as zeroes"..how do i cange it to "as abs values" so i can se the numbers on my graph?

thanks