1 Reply Latest reply on Jun 22, 2018 1:29 PM by Esther Aller

    How to conditionally format by measure name & a specified column?

    Lakshay Akula

      Hi,

       

      Working on a dashboard with some conditional formatting. The idea is that you can see conditional formatting for a few metrics by certain categories. So in the example below, you can see discount and profit ratio broken down by region / category.

       

       

      The issue is, I want to use a different conditional formatting rule for each furniture vs. office supplies vs. tech. So "Furniture - Discount" should have it's own conditional formatting rule.

       

      I understand I could solve this problem by creating a new field called "Furniture - Discount" but this is not a viable solution in my scenario for other reasons. Any suggestions?

       

      Best,
      Lakshay