Tree Map - Need a treemap showing data colors as Green or Red

[rveerasamy]

Hi

We have been provided a treemap sample (Refer Image 1).

However the tree map visual is Power BI as far as I know does not support condition based Data colors that would display negative values to be shown in shades of red and positive values to be shown in shades of green. We should also be able to show a similar legend as in image 1.

Does anyone know if there is an appropriate visual in power bi to get simmilar results.

Thanks for your help

Matthew

[rveerasamy]

negi007, We will try your solution and get back to you

[negi007 · Accepted solution]

@rveerasamy  ok. i was looking into your problem then came up with interesting solution. 

As you know, powerbi treemap can only represent positive value as it shows the shape size basis the value. bigger the value, bigger the size. 

1. let's assume your data is similar to below table. First two columns are data and last two columns are calculated values

we can have only positive values to show the correct map

change% new = ABS('Table'[Change%]) 

this will be used to conditional format positive and negative actual values

color_coding = if ('Table'[Change%]<0,"Red","green") 

2. below is how you put values in your visual

i have attached the pbix file as well here. this will help you and others who are looking for similar solution.