Forum Discussion
Background color variation in cells conditional formatting different than Excel
Hi everone,
I'm trying to get a table in PowerBI to format background color in a table based on value sum. It works but the color variation looks very differnet than in the same table on Excel. the Excel table has a much wider array of "in-between" yellow and orange colors while the PowerBI are almost entirley green or red. It should work the same way though because the scale in both of them is red-yellow-green. Any idea on how to change this?
Thanks!
Hi Anonymous ,
In your data structure,you have a large amount of "lowest value",and the data span between "lowest value " and "middle value" is very large,so you'd better define a middle value to make the color formatting more obvious.pls see below:
And you will see:
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
2 Replies
- Pragati11
Super User
HI Anonymous ,
If I see the picture that compares color in Power BI amd Excel, they are different shades of GREEN color.
Please refer to color-codes in Power BI which will be similar to that you see in Excel.
https://www.rapidtables.com/web/color/RGB_Color.html
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
v-kelly-msftCommunity Support
Hi Anonymous ,
In your data structure,you have a large amount of "lowest value",and the data span between "lowest value " and "middle value" is very large,so you'd better define a middle value to make the color formatting more obvious.pls see below:
And you will see:
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
