Conditional formatting font color in table not working on mobile device

I have a table visual which has conditional formatting turned on. The font color of a column changes to red or green depending on if value is < or > 0. This works well in Desktop and the PBI service, but when I open the report in either iPhone or iPad, the conditional formatting is not working. The value is always displayed in black.

Re: Conditional formatting font color in table not working on mobile device

After further testing, I have narrowed down the problem. The column I was formatting was a traffic light colume, which is simply a calculated column with the formula "=UNICHAR(9899)". It seems that the conditional formatting is failing when using the UNICHAR value.

Anyone know any other options to get a circular traffic light in a table?

Re: Conditional formatting font color in table not working on mobile device

Hi @mshenhav Thanks for the reply. I have narrowed the problem down further. I created sample project (which I will email to you), and I have tried it on 2 different computers. On one, the circle is showing green and red in PBI Desktop, but on the other it is always black, as you are seeing. The only difference is the OS. The one where it works is Windows 7, while the one where it doesn't is Windows 10. Could this explain the problem?

In the mean time, I have changed from a circle to a square character, and the conditional formatting now works everwhere. I am using UNICHAR(9632).

Re: Conditional formatting font color in table not working on mobile device

Hi, I am having the same issue. Using UNICHAR(128308) when a value is 1, format font to green, else no format. Works fine on desktop and web service, but app for IOS shows all as red. Any suggestions would be appreciated.