Forum Discussion
Conditional Formatting in Powerbi tables
Hi,
Below is my sample data set
| Prior Date | Latest Date |
| 7/21/2018 | 7/22/2018 |
| 7/22/2018 | 7/22/2018 |
| 7/23/2018 | 7/22/2018 |
| 7/24/2018 | 7/22/2018 |
Here i want to conditional format the latest date column(one column only) such that,
if latest date > prior date then bgcolor = grey and font color is red
else if latest date <= prior date then bgcolor=grey and font color Green
I tried to explore this using conditional formatting window but it has limited options.
Can someone guide how this can be acheived?
Make a calculated column that provides 0, 1 or 2 based on your criteria, then you should be able to use that calculated column in "Color Based On", click the "By Rules" checkbox and you'll be able to add your rules there.
Hope this helps
David
2 Replies
Make a calculated column that provides 0, 1 or 2 based on your criteria, then you should be able to use that calculated column in "Color Based On", click the "By Rules" checkbox and you'll be able to add your rules there.
Hope this helps
David