Forum Discussion
Coloring the cell if it is empty
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
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
1 Reply
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