Conditional Formatting not matching between Desktop and Web Service

[nzcatala]

Hello everyone,

Hopefully a quick solution, but I haven't been able to find much on the topic.

Basically, as the title implies, I've built out some conditional formatting rules within my PowerBI report.  It's fairly simple, if a metric beat the target, it's green, otherwise, it's red.  

Everything looks great in the Desktop version of the report, but after the first refresh in the webservice all of my Percentage based metrics flip to the wrong color.  On the desktop they'll show green because the beat the target, but on the web it'll show red.  No data has changed, I've tried refreshing multiple times to fix, it looks fine in the Desktop version, and it's only the percentage metrics.

Any insight would be great!

Thanks!

[v-easonf-msft]

Hi, @nzcatala 

Have you  checked the data formatting of the percentage field?

If you are the owner of the report, it is recommended to  edit the conditional formatting of the report again on the PowerBI Service and check if there are any errors.

Best Regards,
Community Support Team _ Eason

[nzcatala · Accepted solution]

Thanks for the response!

I actually did just as you recommended yesterday evening and I did notice that the field that I was using to determine the conditional formatting was having different results on the PowerBI service.

Basically the issue I identified was I was using information from a Yes/No field in a SharePoint list to determine some of the information for the conditional formatting, but I didn't format the field as a True/False column, I left it as the default "any" column type.  Then, when the data came into the report I wrote formulas that would look something like = "TRUE" or "FALSE" to determine the conditional formatting.  Once this was put into the web service, and I'm not sure exactly why, all the "TRUE" and "FALSE" values in the columns turned into 0s and -1s so then the IF = "TRUE" statements would no longer work.  After changing the field to True/False and fixing the formulas everything worked like a charm.