cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cmncp Regular Visitor
Regular Visitor

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.

 

Has anyone else had this problem?

6 REPLIES 6
cmncp Regular Visitor
Regular Visitor

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?

Power BI Team mshenhav
Power BI Team

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

Hey @cmncp,

 

Can you please share with us the PBIX file (to mpbisup@microsoft.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)

 

Thanks, Maya

cmncp Regular Visitor
Regular Visitor

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

Power BI Team mshenhav
Power BI Team

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

Hey @cmncp,

 

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.

 

Thanks, Maya

AndrewHasman New Member
New Member

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.

Highlighted
Power BI Team mshenhav
Power BI Team

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

Hey @AndrewHasman,

 

I am unable to make the below work in Power BI desktop. Can you please share a sample PBIX file that works in desktop for you?

 

Thanks, Maya

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 54 members 1,176 guests
Please welcome our newest community members: