Forum Discussion

vaasubabu's avatar
vaasubabu
New Member
1 year ago
Solved

Conditional formatting using difference from previous month in matrix chart

Hi, I have created the data in the below format. Monthyear is a custom calculation created in power bi. Requirement is to create a matrix chart and sort the Monthyearin desc order and also co...
Need Help
  • v-prasare's avatar
    v-prasare
    1 year ago

    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

v-prasare's avatar
v-prasare
Community Support
1 year ago

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