Conditional Formatting with Color Gradient for closer to 0 value

[Anonymous]

Hi All,

I intend to show a color range from Red to Green when the values are closer to 0.

Like if the value is 0 Dark Green, 0.99 - lighter shade of green, 0.98- another lighter shade. till 1 which is Dark Re

We use similar color coding in Statistical Model KPIs such as correlation in heatmap(Image attached)

[v-easonf-msft · Accepted solution]

Hi， @Anonymous 

Please refer to this document about how to use color scale to configure conditional formatting.

conditional_formatting Color by color scale 

With conditional formatting for tables and matrixes in Power BI, you can specify customized cell colors, including color gradients, based on field values.

PowerBI allows you to format the cell background or font color by color scale, and you can select the add center color checkbox to specify center value and color. 

Best Regards,
Community Support Team _ Eason

[Crangel]

May I ask, do you know why "Enter a value" is grayed out? The gradient is dynamic to what ever the highest and lowest values are in the data, but i'd like to set my own min and max, 0 and 100, but cant.