Forum Discussion

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

Anonymous
8 years ago
Anonymous,

Please check my example in the PBIX file below. If you still have questions, please share sample data of your table.

https://1drv.ms/u/s!AhsotbnGu1NokzC8lquSkaLxwGmz

Regards,
Lydia

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

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
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!
- Anonymous
  Not applicable
  8 years ago
  What are you putting into the conditional formatting? Can you screen shot it?
  
  Remember that a percentage will be recorded as a decimal number. So 50% will actually be 0.50.
  - Anonymous
    Not applicable
    8 years ago
    Sure, see above :)
    
    yeah, i did notice that the measure comes out as a decimal. Is there anyway to change to display as % (if we can fix the cond form, haha)?