Background color variation in conditional formatting of cells other than Excel

[Anonymous]

Hello everyone

I'm trying to get a table in PowerBI to format the background color in a table based on the sum of values. It works, but the color variation looks very differentnet than in the same table in Excel. The Excel table has a much wider range of yellow and orange colors "between", while the PowerBI is almost entirley green or red. However, it should work the same way because the scale on both is red-yellow-green. Any idea how to change this?

Thank you!

[nandukrishnavs]

@Anonymous 

It is showing the correct color level based on the minimum center and maximum value. 

If you want different color shading, you could choose Format by Rules. or Field value. Then you will get control on the level of color shading.

Please refer to https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[parry2k · Accepted solution]

@Anonymous I see what you are saying and I don't think you have the option to control the colors in this case, but you can surely use other options for conditional formattings, like rules or color from the field.