Question

You have a matrix visual showing monthly revenue by product category. Management wants each revenue cell shaded green when the value is at or above the category's target of 50,000, yellow between 30,000 and 49,999, and red below 30,000. The targets are fixed thresholds, not values stored in the model. You want the coloring to apply automatically as data refreshes. What is the most appropriate way to configure this?

Accepted Answer

Apply background color conditional formatting using the 'Rules' formatting style, defining explicit numeric ranges for each color band

Answer

Apply background color conditional formatting using the 'Color scale' (gradient) formatting style with a minimum and maximum color

Answer

Create three separate measures returning fixed color hex codes and place all three in the matrix values

Answer

Manually select and shade each qualifying cell using the format cell background option after every refresh