Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
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?
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |