2 Replies Latest reply on Nov 21, 2018 5:19 AM by Jasper_VA

    Conditional formatting on row measure

    Jasper_VA

      Dear all,

       

      i have the following Dashboard:

       

      What i want to do is the following: I want to countries as columns colored according to a calculated field. I also want to have another measure (in this case "Global" [Number (whole)] ) colored, e.g. 3=green, 0=red. The "Global" field assigns a number to each of the categories, whilst the calculated field used for the colors in the table assigns a number for each combination of Category and Country. I tried dual-axis but i couldnt get it to work properly.

      Any Ideas?

       

      Thanks in Advance.

        • 1. Re: Conditional formatting on row measure
          Norbert Maijoor

          Hi Jasper,

           

          Upfront, not sure;) but find my approach as reference below and stored in attached workbook version 10.2 located in the original thread.

           

           

          1. D1. Colorformat:

          If [Completion]>=10 then '3'

          elseif [Completion]>6 then '2'

          elseif [Completion]>=4 then '0'

          END

           

          2. M1. Global:

          if {fixed [Category]:max([Completion])}>=10 then 3

          else 0 END

           

          3. Drag the required objects to the indicated locations.

           

           

          drag.png

           

          Hope it helps

           

          Regards,

          Norbert

          • 2. Re: Conditional formatting on row measure
            Jasper_VA

            Hi Norbert,

             

            thank you very much for your answer.

            i think i explained it wrong. The part with the countries is already how I want it to be. The only thing missing is a condiitional formatted column "Global". The best thing would be that Global also has little colored squares, but colored numbers would be "ok".

             

            Best regards,

            Jasper