thanks for explanation and examples
in this workkbook, i am now trying to use if metric > 0 hoping i i would get 3 options True False Null so i can color each
this data will change, it will update every week.. so this value that is in this sheet will change... i only see 1 option which is true becuase the data is positive.... what do i do whaen the data changes, for all 8 metrics, for all 400 scenerios that could take plcae??? why is somehyting so bacisc so diffiucukt in tableu!!?>!>!>!>!>>>???
I found a solution.
1. drag a copy of measure values to the color shelf.
2. set measure values to use separate legends.
3. On each measure color, the settings should be set like the following image. diverging color with green, white, red (this can be changed to whichever colors you want.) start and stop should be set at -.001 and .001. Center should be set at 0.