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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Formating cells based on a value

Dear Community 

 

the situation is as following 

I have a cell that count the difference between the expected delivery date and the actual delivery date;

I would like to flag or highligh cells in red that have a value lower than 7 days 

PS: there are also negative values in the days counted

 

Would you please support on how to flag these cells or highlight them in the visual. I am using a table

 

Thank you and regards

3 REPLIES 3
lbendlin
Esteemed Contributor III

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Anonymous
Not applicable

I have values that are between -12 days to n days. the idea here is to format in red any value lower than 10 days and everything else in green 

lbendlin
Esteemed Contributor III

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to work with. Avoid posting screenshots of your source data if possible.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Helpful resources

Announcements
Users online (4,086)