cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nzcatala
Frequent Visitor

Conditional Formatting not matching between Desktop and Web Service

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!

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

View solution in original post

2 REPLIES 2
v-easonf-msft
Community Support
Community Support

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

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.

View solution in original post

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors