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

Conditional format when value equals Zero

Hello, I have a particular problem when I use conditional format to make a Heat-map. There are values equal to 0 that I want to be painted red, but there are other that theorithically have no value at all, that are blank, and I need the color for those to be white.

 

The logic of the count function is:
#Executed activities / #Total Activities

In some cases there are no activities at all (blank values), in that case how can I paint them white?

 

adrianrolon_0-1605889561032.png

 

0 REPLIES 0

Helpful resources

Announcements
Users online (4,584)