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!

[v-zhenbw-msft · Accepted solution]

Hi @Anonymous ,

We can use the following steps to meet your requirement.

1. Create a measure to rank the value.

rank = 
IF(
    HASONEVALUE('Table'[name]),
    RANKX (
            ALLSELECTED('Table'),
            CALCULATE(SUM('Table'[value])), ,
            ASC,
            DENSE
))

2. Then we can create a measure to calculate the percentage of column.

Measure = CALCULATE([rank]) / MAXX(ALLSELECTED('Table'),[rank] )

3. At last, we can configure the value’s background color based on measure.

We can get the result like this,

BTW, pbix as attached.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous good question, I don't have an answer but you have many options to control the color, read more here on conditional formatting.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!