Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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-
Solved! Go to 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.
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,
Happy to help!
@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.
If the target and actual value is in different table, then how we can do this same?
please help
@Anonymous
It is a measure not a column. So I think I will need to wait until this is implemented. Thanks though!
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |