cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
hassanmoukadem
Regular Visitor

If Cell Date less than is due in 3 days (Format Color) Or Attention

Hello, 

So i am adequetly new to Power BI.

i have a table in which i follow up on incidents with my team, and i have a due date, i want to be notified (color, or any visual) if the due date is getting close, say 3 days or any condition.

hassanmoukadem_0-1696239790872.png

 

 

1 ACCEPTED SOLUTION
v-cgao-msft
Community Support
Community Support

Hi @hassanmoukadem ,

First create a new measure like:

Measure = IF(ABS(DATEDIFF(MAX('Table'[Due Dates]),TODAY(),DAY))<=3,"Red","Green")


Then select the visual --> Format pane --> cell elements -->Select the fields to which you want to apply conditional formatting --> Click the fx button.

vcgaomsft_0-1696407767745.png

Setting up according to the picture.

vcgaomsft_1-1696407879981.png

Output:

vcgaomsft_2-1696407937364.png

Please check the attachment.

 

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

View solution in original post

2 REPLIES 2
v-cgao-msft
Community Support
Community Support

Hi @hassanmoukadem ,

First create a new measure like:

Measure = IF(ABS(DATEDIFF(MAX('Table'[Due Dates]),TODAY(),DAY))<=3,"Red","Green")


Then select the visual --> Format pane --> cell elements -->Select the fields to which you want to apply conditional formatting --> Click the fx button.

vcgaomsft_0-1696407767745.png

Setting up according to the picture.

vcgaomsft_1-1696407879981.png

Output:

vcgaomsft_2-1696407937364.png

Please check the attachment.

 

Best Regards,
Gao

Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Amazing, just perfect and what i wanted.

Thank alot

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors