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

Anonymous's avatar
Anonymous
Not applicable
3 years ago

with your measure 

New = IF(SELECTEDVALUE('Issues'[Date Reported]) <= TODAY()-7, "red") and steps you provided It doesn't highlight anything. It needs to highlight the past 7 day's period
PhilipTreacy's avatar
PhilipTreacy
Super User
3 years ago

Hi Anonymous 

 

So you've created the Conditional Formatting rule after creating the measure? 

 

Without seeing your data and the rule you wrote I can't say for sure what is wrong.  Can you supply your file or at least the data (as text or table - not an image) you are running the CF rule against?

 

regards

 

Phil