2 Replies Latest reply on Nov 29, 2016 12:39 PM by Susan Oner

    Single color range for multiple measures?

    Susan Oner

      I'm looking to create a single color range for multiple measures (that updates dynamically).  i.e. for the example below there are 4 measures (Profit, Sales, Discount, Quantity) each colored by its own separate % measure (Profit Ratio, Sales % to last year, Discount % to LY, Quantity % to LY).  Is there a way to get the color variables to align on a single color range?  In this case it would be -9% up to +25% (minimum of all, maximum of all).  I could hard-code but am wondering if there is a better solution.  Packaged workbook attached. 

      Thank you-  Susan