Conditional Formatting Not Loading After Auto Refresh

[Anonymous]

Hello, I have a report that is displaying real time data on a screen for a production environment. It is using conditional formatting to color the rows of a table visualization. It's reloading every 30 seconds and the data pull is taking less than 1 second. About every 5 to 10 refreshes it is failing to load the conditional formatting. There are multiple tables on the screen all using the same data source and it's almost never affecting all of the tables on the screen at the same time, most of the time just one of the tables fails to load conditional formatting.

It seems that PowerBI is applying the conditional formatting rules before the measures are finished calculating.

This feels like a bug in PBI. Does anyone know a way to fix this or a workaround?

Thanks for any info!

[BDale93]

This issue was infuriating for me. I finally narrowed the issue down to a data type that I changed in my model not transferring over to the web service. So, instead of changing the data type in the model, I changed it within power query and that seemed to resolve the issue when publishing. Hope this helps

[v-tangjie-msft]

Hi @Anonymous ,

After my testing, I did not reproduce your issue. It may be that the visual takes more time to render than the value specified in the Automatic page refresh setting, try increasing the value of the refresh interval. In addition to this, automatic page refresh can put an unnecessary load on capacity or data sources. It may be that the conditional format cannot be loaded due to insufficient memory, please refer to this optimization environment.

Please refer to the following document for more information.

Auto Page Refresh in Power BI - Everything you need to know! - Data Mozart (data-mozart.com)

Automatic page refresh in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.