Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Highlighting new items

This might be a pretty simple thing to do but I am fairly new to Power BI and still trying to learn. I have a simple table of tasks and I want to highlight new items. For instance, anything that is p...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    3 years ago

    Hi Anonymous 

     

    I just used your code in  the example file I created for you and it highlights in red anything that is more than 7 days in the past 

     

    Check example PBIX file

     

    You said you wanted to highlight things posted in the past 7 days, not more than 7 days ago?

     

    To highlight things in the past 7 days you want to use greater than or equal to in the code, the code you posted is using less than or equal to 

     

    New = IF(SELECTEDVALUE('Issues'[Date Reported]) <= TODAY()-7, "red")

     

    regards

     

    Phil

PhilipTreacy's avatar
PhilipTreacy
Super User
3 years ago

Hi Anonymous 

 

Your measure for assigning the color is looking for dates that are greater than or equal to TODAY - 7 days.  At time of writing that means it will highlight things from 28 Oct onwards

 

But in your data the latest date is Oct 24th so that's why nothing is being highlighted.

 

regards

 

Phil