I am making a bar chart to help coworkers understand how they are tracking to their goals. I want the left bar in each region to be colored based on their progress and the bar on the left to be grey.
The calculated field set to color is: ATTR([Orders])-[Orders Target TD]. This produces a correct result but I can't get the right bars to be grey.
put "Measure Names" as color and edit the color