Forum Discussion

maurcoll's avatar
maurcoll
Icon for Helper IV rankHelper IV
4 months ago
Solved

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 ord...
Need Help
  • Kedar_Pande's avatar
    Kedar_Pande
    4 months ago

    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's avatar
grazitti_sapna
Icon for Super User rankSuper User
4 months ago

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!