Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
AngryITSysAdmin
New Member

Highlight Cell based on Today -15 days

Hello. I really need some help. I am new to PowerBi, I did browse for a solution but this is a bit beyond me. All I want is to highlight in red the cells that are older than 15 days (or if it blank). Each column is data from a different source. I read refences about Conditional Formatting but I couldnt get them work. I also saw stuff about Measures (Today() or Now()), custom columns, DAX and it is a bit over my head for now.

 

When I create a measure and try to apply it to a Conditional Format rule it just goes blank, as if there was an error with the measure or it can't be used against a date column, i really dont know. 

 

Any help is greatly appreciated. Thanks.

 

Agents.png

2 REPLIES 2
parry2k
Super User
Super User

@AngryITSysAdmin how does raw data table looks like?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

The Raw table comes from databases. The T_LastConnectUtc:

 

lastconnect_2.pnglastconnect_3.pnglastconnect_1.png

 

I hope this answers your questions. Thanks for the assistance.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors