Treemap Color Saturation

[franorio]

Hello everybody!

I created a dashboard, I need to create a Treemap with color saturation or conditional formating, let's say, if a specific KPI reaches the target = green, if 10% beneath the target = yellow, if it's even below = red.
already know how to select the colors but i´m having dificulties on choosing the right Color Saturation parameter.

Dashboard receives information from 5 Tables, I created a specific Measure for each table. So those 5 measures are my Treemap Values, also created a new table with the specific comun areas under they should be group ¨Dashboard¨.

The question is, which paramet should i create for color saturation? Adding one of the 5 KPImeasures under values, like the picture, doesn´t work for the others kpi´s.

Created a new column, with the targets ( 90%, 100%, 90%, 90%, 90%), but also didn´t work.

Any ideas? thanks a lot!

Regards!

[v-ljerr-msft · Accepted solution]

Hi @franorio,

The question is, which paramet should i create for color saturation? Adding one of the 5 KPImeasures under values, like the picture, doesn´t work for the others kpi´s.

I don't think it is possible to do it currently. The color saturation in Treemap works for different items in Group field, not the items in Value field. So all your 5 KPI measures(in Value field) will have the same color for a specific item of Group on the report, and there is no option to change this default behavior currently.

In this scenario, I would suggest you to submit your requirements on Power BI Ideas and vote it up to improve Power BI on this feature.

Regards