Forum Discussion
Conditional Formatting on %
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
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.
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
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.
Thanks Anonymous,
I created this measure (which gave me the right number), but it still doesn't seem to work!
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.