Forum Discussion

CG_FinXO's avatar
CG_FinXO
Regular Visitor
3 years ago
Solved

Changing Card Colour based on Date Condition

Hello,   I'm relatively new to Power BI and am looking to create a rule that changes the colour of a card in power BI, if the value is over x age (for example if the date/ time value is over 1 week...
Need Help
  • Dhairya's avatar
    Dhairya
    3 years ago

    IsWithinLast7Days = IF(MAX('YourTable'[DateColumn]) >= TODAY() - 7 && MAX('YourTable'[DateColumn]) <= TODAY(), "1", "0")

    Use above measure for conditional formatting and set rules for same
    if measure value is 1 then set color to red, similarly for 0.

Dhairya's avatar
Dhairya
Solution Supplier
3 years ago

Hey
You don't have to plot that measure on visual, just use that measure for conditional formatting, and apply rule for same that if the output of your measure is 1(less than 1 week) then color it red.

If still you are facing issue please share your sample dataset and measure you created.

CG_FinXO's avatar
CG_FinXO
Regular Visitor
3 years ago

HI Dhairya,

 

I'm not 100% on the correct input for the measure. I've included an example of the data and fields below:

 

 

  • Dhairya's avatar
    Dhairya
    Solution Supplier
    3 years ago

    IsWithinLast7Days = IF(MAX('YourTable'[DateColumn]) >= TODAY() - 7 && MAX('YourTable'[DateColumn]) <= TODAY(), "1", "0")

    Use above measure for conditional formatting and set rules for same
    if measure value is 1 then set color to red, similarly for 0.

    • CG_FinXO's avatar
      CG_FinXO
      Regular Visitor
      3 years ago

      Thank you for all your help!