Forum Discussion

arouillard's avatar
arouillard
Regular Visitor
9 years ago
Solved

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...
Need Help
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
9 years ago

arouillard,

 

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.

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tips-and-tricks-for-color-formatting/#customize-the-colors-used-in-the-color-scale

 

As an alternative, use SIGN Function to create a calculated column.

Color Saturation Flag =
SIGN ( Table1[Column3] - AVERAGE ( Table1[Column3] ) )
arouillard's avatar
arouillard
Regular Visitor
9 years ago

The SIGN function is perfect !

 

Here is my calculated measure:

Flag_Market_Share_Saturation = SIGN([Market Share] - (DIVIDE(CALCULATE(SUM(Database_Fusion[Group - Excel]);ALLEXCEPT(Database_Fusion;Database_Fusion[Addressable market]);Database_Fusion[Flag_ThisYear] = 1);CALCULATE(SUM(Database_Fusion[Market - Excel]);ALLEXCEPT(Database_Fusion;Database_Fusion[Addressable market]);Database_Fusion[Flag_ThisYear] = 1))))

 

Thanks a lot for your help !