Forum Discussion

FlavioMe3101's avatar
FlavioMe3101
New Member
2 years ago
Solved

Conditional formatting

Hello, I am facing a challenge with a business intelligence (BI) project that I am working on. The project involves displaying the expiration status of some fruits in a table.  The table has the firs...
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi FlavioMe3101 

    Please follow the articles that shows all options of conditional formatting 
    https://blog.coupler.io/power-bi-conditional-formatting/

     

    For your requirement please follow point no 4, conditional formatting with measure.
    Please create a measure for Date change and use the measure as conditional formatting.


    Let me know if that works for you


    If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

    Thanks
    Pijush
    Linkedin

MFelix's avatar
MFelix
Icon for Super User rankSuper User
2 years ago

Hi FlavioMe3101 ,

 

Create a measure similar to this one:

Color format = IF(MIN(Calendar[Date]) >= SELECTEDVALUE(Table[Valid]) , "Red")

 Then use this metric has your condittional formatting.

 

I assume that the date you have on the columns comed from a calendar table or similar.