Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |