set the font color of a field based on another field in same row.

[ppgandhi11]

Hi,

I reviewed the page: https://community.powerbi.com/t5/Desktop/how-to-get-font-colors-of-a-column-based-on-other-column-va...

I have latest edition of the Power BI Desktop. Has this feature been incorporated since the idea above has been posted? I have already casted my vote in case its not there. I don't see it implemented.

This is my requirement. Paint font in Column1 red when the Column2 values are higher than Column1. Paint it green otherwise. Is there a way to do so in power bi?  Thanks!

Prashant-

[ibarrau]

Just like rajendran said you can format one column with another one. You can add a column3 with the name of colors and have another table like this:

IdColor    Color

1              red

2              green

3              other

Add a relationship between column3 and color

Then, when you format conditional to column1 or 2, use idColor to add the conditions.

Or just put the number on the column3. The first one is a better practise.

Regards,

[Anonymous · Accepted solution]

@ppgandhi11, this is possible if your values are at the column level. You can make a calculated column that checks if your first value is higher than the second value, and that result can be a numeric 1 or 0.

From there, you can use the conditional formatting based on another column. See screenshots below.

[Anonymous]

If the target and actual value is in different table, then how we can do this same?

please help

[ppgandhi11]

@Anonymous

It is a measure not a column. So I think I will need to wait until this is implemented. Thanks though!