Forum Discussion
Treemap Color Saturation
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!
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.:smileyhappy:
Regards
1 Reply
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.:smileyhappy:
Regards