Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Reply
dterest
New Member

Conditional Formatting created in Desktop version are lost when dataset is refreshed online

Hello, 

I have created a report with a table that applies a specific background color to a cell based on the value from another using a conditional formatting rule as seen below. The field Region_Priority only contains 0 or 1 values. 

 

dterest_0-1699310886470.png

When I open the report from Power BI online, I can see the background color. But if I refresh the data set afterwards directly from Power BI online, the conditional formatting is lost. 

 

Does anyone have encountered this issue before? I have been searching the community but I couldn't find another post with this particular issue of losing the formatting after refreshing. Help will be kindly appreciated. 

 

dterest_1-1699311871302.png

 

 

 

 

1 REPLY 1
ChandraTeja
Frequent Visitor

Can you provide more details about the column being used in the calculation?  I think its called Region_Priority in your calculation - that might give us more information about what is changing when the dataset is updating.

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.