Issue with Dynamic Background Colors in Bookmarked Reports

[gnnpbi]

Hi Power BI Community,

I'm encountering an issue with a report that uses dynamic background colors in a table, which change based on the current time. When a user accesses the report through the Power BI service and bookmarks the page, the cell background colors stop updating.

Steps taken:

• Cleared the browser cache (did not resolve the issue).

This is problematic because users need to create their own bookmarks without breaking the core functionality of the report.

Has anyone else experienced this issue or have any suggestions for a solution?

Thanks in advance for your help!

[Anonymous]

Hi,@gnnpbi .I am glad to help you.
May I ask if you are having a problem with power BI Service is it (and not Power BI Report Server)
You mentioned that your report has a dynamically changing background, do you mean a conditional format that changes dynamically in the power bi report based on the value of the measure?
Currently Power BI supports the use of a certain report background Theme
URL:
Power BI Theme: How To Simulate Dynamic Theming – Master Data Skills + AI
Solved: Change report background color dynamically - Microsoft Fabric Community 
Could you please tell me if what you are describing is the following situation: before creating a bookmark on Power BI service, when refreshing the report, the measure data will be dynamically updated and the background of the application will be dynamically changed, but after creating the bookmark, the cell background conditional formatting set is no longer changed (although the value of measure still changes)
If this is the case, I hope my test below can help you.

I bookmarked the report in the Power BI Service

Then I click the refresh button and the report is dynamically updated (the measure I created is dynamically changing, recording the seconds between current values).
When I refresh the report by clicking the browser refresh button in the top left corner of my browser and reopen it, the measure and the applied condition formatting changes and works fine. Other external filters such as slicers remain the same.

As you can see here I have measure=10 for bookmark4,measure =9 for bookmark3

When I select bookmark4 and hit refresh, the value of the measure is successfully updated (the slicer filter conditions are not affected)
bookmark4's measure was updated to 40, and at that point bookmark3's measure was also updated to 47 (instead of the 9 it had just been)

Bookmark3's measure result = 47 (no refresh at this point)

Note that.
A bookmark acts as a static record of the current state of a report. It saves the current state of the report, including data and formatting.
Whereas Power BI reports are static by default, dynamically changing metrics and conditional formats are updated only when the user manually refreshes the data. This is a known behavior of Power BI.
This indicates that if you do not update the latest data in power BI Desktop or Power BI Service (without clicking the refresh button, or doing other operations that modify the pbix file, such as creating a new visual, writing new dax code) then the dynamic results of the report will always be displayed statically, whether or not bookmarks are created.

If my understanding is off, please let me know and provide more information about the error, including the version of Desktop and Service used.
This is the version of Power BI Desktop and Power BI Service I am using.

Power BI Service version

Power BI Desktop version

If you are able to provide the relevant software version information, this will help to solve your problem (please provide your version number)

This is my test code:

CurrentSecond = SECOND(NOW())



M_Animated backgrounds = 
VAR _time=MAX('TestTime'[Time])
VAR _TensPlace1 = MOD(INT(DIVIDE(_time,10)),10)
VAR _Tenscurrent=MOD(INT(DIVIDE([CurrentSecond],10)),10)
RETURN
IF( _TensPlace1= _Tenscurrent,1,0)

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.