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

FBergamaschi's avatar
FBergamaschi
Super User
1 year ago

I do not get what the problem is, please help me understand it

 

You show this Output to achieve

 

but here the months is not sorted in descending order

 

So can you specify what do you have now as result and what do you want to get?

 

Thanks

vasubabu's avatar
vasubabu
Frequent Visitor
1 year ago

It appears the sort order isn’t working correctly. Here’s how the output should look:
For January 2025, sales are 50. Then for February 2025, sales drop to 15. This decrease should be highlighted in red.
For February 2025, sales are 15. Then for March 2025, sales rise to 25. This increase should be highlighted in green.