Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Card with Conditional Formatting

I am trying to do what i thought would be a simple task with a card and it's driving me insane!   I have a card which shows % vs target using a meaure field and I have another measure which calcula...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous ,

 

I think below is what you want:

Please try.

Aiolos Zhao

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi, I want to use a calculated measure to achieve this result but the conditional formatting by field selector won't allow me to select the field I need

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous ,

     

    I'm not sure why you can't select the measure you need, because it works on my desktop.

    if it's possible, could you please share you measure expression.

     

    In my sample, I choose the "Format by Field Value", then select the measure I created.

     

    Aiolos Zhao

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Sure it's just a simple division.  Tried as a measure and column and it won't allow me to click OK

      PTD % Target = DIVIDE([Days PTD],[Days in Period])
      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Anonymous ,

         

        Sorry for reply late, yes, for this measure you can't use "Format by Field Value",

        for this measure, you need to use "Format by Color Scale", then choose the range then color that you want.

         

        Please try.

        Aiolos Zhao