cbhoffm1's avatar
cbhoffm1
Advocate I
6 years ago
Status:
New

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 in the Workspace

Conditional formatting setup

8 Comments

  • v-yuta-msft's avatar
    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.

     

    Regards,

    Jimmy Tao

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

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
    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's avatar
    v-yuta-msft
    Community Support

    cbhoffm1 Anonymous Anonymous 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