Forum Discussion

dterest's avatar
dterest
New Member
2 years ago

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. 

 

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. 

 

 

 

 

 

1 Reply

  • ChandraTeja's avatar
    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.