01-09-2019 03:22 PM
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.
Has anyone else had this problem?
01-09-2019 04:06 PM
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?
01-10-2019 12:32 AM
Can you please share with us the PBIX file (to email@example.com)?
I was trying to reproduce the issue, but could not get the font color change to for that specific unichar, both in desktop and web...
other unichar (UNICHAR(9650) for example) is working as expected in all platforms (inc. mobile)
01-10-2019 01:36 PM
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).
Since the problem exists only for specific char and in all platforms (and not mobile specific issue), can you please post your issue at Power BI Desktop forum (https://community.powerbi.com/t5/Desktop/bd-p/power-bi-designer)? They should be able to better investigate it.
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.