Forum Discussion
Conditional Format on date change
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
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.
2 Replies
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!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.
