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,

We would like to follow up to see whether our super users answer resolved your issue? Please let us know if you need any further assistance.

 

Ashish_Mathur, danextian & FBergamaschi, Thanks for your prompt response.

 

 


Thanks,

Prashanth Are

MS Fabric community support