Forum Discussion
Conditional formatting of PowerBi table
1. You can do this way
select each column and then apply conditional formatting with the same rule
2. you can use what color you want:
DateDueColor = if(DATEVALUE(left('Table'[DateDue],4)&"-"&MID('Table'[DateDue],5,2)&"-"& RIGHT('Table'[DateDue],2))<=TODAY(),"LIGHT BLUE",if(DATEVALUE(left('Table'[DateDue],4)&"-"&MID('Table'[DateDue],5,2)&"-"& RIGHT('Table'[DateDue],2))<=TODAY()+30,"YELLOW","#70BBFF"))3. You can remove the column and it function
Solution SageHi,
You can try this way:
creating a calculated column:
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
Hi there,
thanks for your response. It worked! However, three questions:
1. I would like the entire row to be conditionally formatted rather than the column - for instance, if line item one is overdue, I want that entire row in the table to be red)
2. The green color shown is too dark so how can I change the shade of green with a custom hex # instead of standard green for instance?
3. I don't want the DateDueColor column to be in my table. I now have a column with values of GREEN, YELLOW and RED. How do I remove this from the table without eliminating the formatting?
- serpiva64
1. You can do this way
select each column and then apply conditional formatting with the same rule
2. you can use what color you want:
DateDueColor = if(DATEVALUE(left('Table'[DateDue],4)&"-"&MID('Table'[DateDue],5,2)&"-"& RIGHT('Table'[DateDue],2))<=TODAY(),"LIGHT BLUE",if(DATEVALUE(left('Table'[DateDue],4)&"-"&MID('Table'[DateDue],5,2)&"-"& RIGHT('Table'[DateDue],2))<=TODAY()+30,"YELLOW","#70BBFF"))3. You can remove the column and it function