Forum Discussion
Changing Card Colour based on Date Condition
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.
Hey CG_FinXO
To achieve this functionality you can create measure that returns 1(less than 1 week) and 0(more than 1 week) and then you can add rule in conditional formatting of Card.
If this helps you please mark my solution as accepted !
Hi Dhairya,
Thank you for your response! I created the measure using your instructions, but when I add the measure to the field where the date is also being pulled from, I recieve 'can't display visual'.
Would you be able to elaborate a bit more on how you would add this into the 'card with states' visual?
Thank you!
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.HI Dhairya,
I'm not 100% on the correct input for the measure. I've included an example of the data and fields below:
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.