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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Conditional Background Stopped Working

I have an image that I have applied conditional formatting to.  The conditional formatting works fine in  Power BI Desktop and it was working last week; however, now the conditional formatting does not seem to be applied at all.

 Image with conditional formatting in Power BI DesktopImage with conditional formatting in Power BI DesktopImage in the WorkspaceImage in the Workspace

Conditional formatting setupConditional formatting setup

Status: New
Comments
v-yuta-msft
Community Support

@cbhoffm1 ,

 

I could reproduce your issue. The solution is to click the "Refresh" button in the report page. This issue should be related to browser cache, please clear the browser cache.

Capture.PNG

 

Regards,

Jimmy Tao

iqvia_jfls
New Member

I tried using the Refresh button through the service and yes it does make the images show, but only for that single session.  If you reopen the report or even navigate to a different tab, it shows as it previously did.  Also, I logged into the service using an incognito window to make sure there were not cache issues and the same issue exists.

cbhoffm1
Advocate I

Hi Jimmy (@v-yuta-msft ),

 

Our end users view the report through a portal and don't have access to the refresh button.  It also doesn't make sense to ask the user to refresh the report immediately after it has initially loaded.  Also please see @iqvia_jfls response above regarding the navigation across tabs.

jarjac
Frequent Visitor

Hi,

we are experiencing the same issue using conditional formatting on background color on buttons. It works in the desktop but has stopped working in the service. 

best regards

Jarle Jacobsen

Anonymous
Not applicable

I'm facing this exact issue too. I'm using the contional formatting to a field value:

 

MakeButtonTransparent = IF(ISFILTERED(Sheet1[SlicerValues]), "#4363d8", "white")

 

This worked perfectly on the desktop workspace, but once I published it to the online service the conditional formatting isn't working in the same manner. The report loads fine and looks good upon opening it online. However, once a selection is made in the slicer it's as if the conditional formatting of the background color on the button is reversed.

 

Dekstop Version:

Desktop-NoFilter.JPG

 

Desktop-Filtered.JPG

 

Online Version:

first opening:

Screen Shot 2019-10-24 at 2.46.58 PM.png

Slicer selection made but button background stays white

Screen Shot 2019-10-24 at 2.47.13 PM.png

Cleared the slicers and now the background color of blue appears

Screen Shot 2019-10-24 at 2.47.25 PM.png

v-yuta-msft
Community Support

@cbhoffm1 @Anonymous @jarjac @iqvia_jfls ,

 

Sorry for late, this should be a HTML bug. I will report this issue internally and update here when I get any response from PG.

 

Regards,

Jimmy Tao

v-yuta-msft
Community Support

@cbhoffm1 @Anonymous @jarjac @iqvia_jfls ,

 

The issue has been fixed.

 

Regards,

Jimmy Tao

Jeff_Ng
Frequent Visitor

I think this issue has somehow managed to make it way back. I believe it is the same issue that I am facing now. I already raise it here still looking for solution. Conditional formatting corrupted in Service - Microsoft Power BI Community  Please help.