Conditional formatting using difference from previous month in matrix chart

Hi vaasubabu ,

In the matrix visual, when using a full Date table, dates with no corresponding sales records result in blank values for measures like Revenue or MoM Difference. To avoid displaying these blanks, which negatively affects user experience — you can replace them with zeros by updating your measure as follows:

Total Revenue = COALESCE(SUM(Data[Revenue]), 0)

This ensures that even on dates with no transactions, the matrix displays 0 instead of a blank, leading to a cleaner and more consistent report.

Thanks,

Prashanth Are

MS Fabric community support