Conditional Format on date change

[maurcoll]

Hi is it possible to conditional format a matrix if a number has changed between dates. I have two dates that i am comparing the ordered date and the order due date. I want to format if the total order number change

Ordered Date / Order Due Date	15/06/26	16/06/26	17/06/26
01/05/26	25	28	3
02/05/26	26	25	3
03/05/26	26	25	3

I want to be able to highlight the changes as identified in the above so the based on the ordered date

[Kedar_Pande · Accepted solution]

@maurcoll 

Change Color = 
VAR _current = [Order Count]
VAR _prev = 
CALCULATE(
[Order Count],
PREVIOUS('DueDate'[Order Due Date])
)
RETURN
IF(_current <> _prev && NOT ISBLANK(_prev), "#FFFF00", "#FFFFFF")

Set the matrix cell background to Field Value using this measure.

[grazitti_sapna]

Hi @maurcoll,

Yes, you can achieve it by creating a measure for apply color change. 

Create a measure with your conditions.

add your required data to matrix

go to cell elements -> select where you want to apply change (e.g.Background or font)

Select the measure which you just created

Attached is an example .pbix for you.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!