Forum Discussion

melina's avatar
melina
Helper IV
9 years ago

Color row based on date condition

Hi, Can i formatting the table in Report (desktop) and dashboard, for example in one table i want to change row colour based on date condition, for the pass date i want the table row became red,cu...
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi melina,

Do you mean DAX? If so, we are not able to achieve your requirement using DAX.

A workaround is to create a new column using the following DAX, and then create a bar chart to display SO number in different color.
Column = IF(Table3[Closing Date]>=TODAY(),"Green","Red")



Thanks,
Lydia Zhang

melina's avatar
melina
Helper IV
9 years ago

Thanks for your answer