Forum Discussion
Color formatting a cell with zero value in a decomposition tree visual
I have a decomposition tree set up and have conditional formatting on the values so they turn either red or green if one of the columns is yes or no. Then i have a count of people in another colu...
parry2k the data source has zero's in it.
If i put those as null in power query then they disappear completely from the visual.
But i need them to show as zero, but then as those would be non-compliant (or they are a no), I need those to also show as red. I only want the ones that are yes to be green.
I haven't added any other parts to the measure to force it.