Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Conditional Formatting on %

Hi,    I'm trying to put some conditional formatting on %s in a matrix table, but it doesn't seem to be working...   any ideas?   Thank you!   Sonia
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

hi Anonymous, 

 

Thanks for your response!

 

I tried creating new calculated columns to get the %, but it still doesn't seem to be working. 

 

It's strange, because I've managed to do exactly the same thing before... 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Correct, calculated columns would produce the same issue.  Measures are different but can be used to create a similar outcome for the purpose of a visual.

 

Measures are context sensitive, so you could write a measure to simply take the first value in a column (Text) or for a Max value of a number.  If the context of your visual is such that you are getting 1 value per line anyway, the measures context will only ever be that single value.  Thus the measure will provide you with the same result, but the conditional formatting seems to be kept happier.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks Anonymous!

     

    Are you able to provide some more detail into the DAX i should use for the measure? 

     

    My calculated columns are just MOM change and YOY change 

    Thanks again!

     

    Sonia

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      The measure would look something like

       

      MOM Display = MAX('YourTable'[MOMField])

      Nothing all that fancy, now if you bring that into the table as if it was a field, it should display the same information.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Thanks Anonymous, 

         

        I created this measure (which gave me the right number), but it still doesn't seem to work!