Forum Discussion
arouillard
9 years agoRegular Visitor
Problem with Treemap
Hello Power Communauty, I have a little problem with the Treepmap visualisation. I have 2 measures, one representing the Market size (Box size) and the second representing the Market Share (C...
- 9 years ago
By default, the lowest value in your data is mapped to the least saturated color, and the highest value to the most saturated color. Center value is just the arithmetic mean of Minimum and Maximum, not all values. You may set them manually through Data colors section in Format pane.
As an alternative, use SIGN Function to create a calculated column.
Color Saturation Flag = SIGN ( Table1[Column3] - AVERAGE ( Table1[Column3] ) )
arouillard
9 years agoRegular Visitor
Think I understood the problem.
The color saturation don't take the VALUE as center, but that take the Center between the Higest and the Smallest Value.
For example, If I have Value A = 10 and B = 1000, the color saturation will take (1000-10)/2=495 and not (1000+10)/2=505...
That's why ! Do someone have an idea to correct that ?
Regards,