Forum Discussion
Conditional Formatting with Color Gradient for closer to 0 value
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)
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
2 Replies
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 _ EasonMay 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.
