Creating Visuals that do not update

[Selwynster]

Is it possible to disable certain visuals from updating when you click the refresh button?

So i would like to duplicate a visual but keep one as a historical view.

[v-juanli-msft · Accepted solution]

Hi @Selwynster

there is no direct option on a visual to disable refresh.

However, here is a workaround you can take into consideration.

In the query editor, first copy the dataset, then in this copied dataset, you can right click on a query to select or deselect the option "Include In Report Refresh" and "Enable Load".

Then create a “history table” that store the history data, uncheck “"Include in Report Refresh" option so to disable the refresh to this table. You can refer to this article to achieve your goal better.

Best Regards

Maggie

[Hardik]

https://community.powerbi.com/t5/Desktop/Bookmark-update-december-2017-All-Visuals-vs-Selected-Visua...

Hope this helps

[Selwynster]

It seems Bookmarks apply to filters or slicers.

I am not using any, but still need an option for a Visual not to change if I Refresh.