Negative value aren't supported and...abs value?

[mircogia]

Dear All,

i'm doing a treemap, and i would like the negative values to be displayed as abs values, while at the moment i have them displayed as zero. How can i do? please notice that the field does not come from a measure, is a field on my excel database.

thanks 

Mirco 

[DataZoe]

Hi @mircogia ,

I'd suggest that you create a measure based on the column that is coming from excel to transform the data. Maybe this would work?

 Measure =
ABS ( SUM ( Table[Value] ) )

[mircogia]

hi, i saw the solution but i don't understand what it means "You could try to measure to show negative  value" , any advice? 

as i would need to know anyway when is negative, i didn't want to convert the data

thanks 

[DataZoe · Accepted solution]

@mircogia Treemap doesn't support negative values, so if you need to see the negative values, you may need a different visual.

Another thought I had was the do the measure as I showed, but then add a calculated column to categorize them as negative or positive.  Then have a treemap that way, like this:

The calculated column is fairly straightforward:

Positive or Negative = if(NegTreemap[Value]>=0,"Positive","Negative")

[mircogia]

that's a good idea!! many thanks for the advice 

[Anonymous]

Hi @mircogia ,

So your issue is solved,right?Could you pls mark the reply as answered to close it?

Much appreciated.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Pragati11]

Hi @mircogia ,

There is an existing thread for this:

https://community.powerbi.com/t5/Desktop/displaying-negative-values-in-Treemap/m-p/847381

Thanks,

Pragati