Coloring the cell if it is empty

[Michael92]

Hello all,

I have table in the report and there is a date column.

I need to color the cell red if the cell is empty and green if it is not.

Is it possible?

Thank you

Michael

[v-shex-msft · Accepted solution]

HI @Michael92,

Did these empty records really include in your table? If not, you may need to create an unconnected table with correspond column/row category feilds to use on matrix column/row fields.

Then you can write Dax formula to use current row/column contents to lookup raw table values and use this as condition for color formatting.

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn
Regards,

Xiaoxin Sheng