Conditional Formatting on %

[Anonymous]

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 · Accepted solution]

@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]

What data formats are the percentages? Have you tried creating a measure to display the information?  I've had troubles in the past with Conditional Formatting which all resolved when i created a measure to do display the information.

[Anonymous]

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]

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]

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]

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]

Thanks @Anonymous, 

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

[Anonymous]

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]

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)? 

[Anonymous]

Yes you can format as a percentage, all you need to do is click on the measure (after creating it you need to click elsewhere and click back).  In the modelling section of the ribbon, there is an area to select the data type and the data format.  You can select Percentage from there.

In the colour by rules, you should be able to select a single condition for each row.  That being less than Zero and Greater than or equal to 0.  I still would have expected this to work.  I notice it is "Font Colour Scales", so part of me also wants to check if the change has happened but is a little subtle?

[Anonymous]

Here is one that i did on some percentages.  This one does red for below zero and green for above 0.

I used a colour gradient instead, but the theory should be similar:

[Anonymous]

Thanks @Anonymous, 

still not changing my number! So strange... 😞