topic Re: Refresh visual - manual in Developer

Refresh visual - manual

wvanpeel — Wed, 20 Jul 2016 14:57:52 GMT

I have a report (Matrix) that has somewhat detailed level data and calculations.

With this report I want to avoid that the result is refreshed every time a user clicks another value in the slicer(s).

Is it possible to refresh the matrix report manually, after slicers (filters) have been chosen?

Don't get me wrong, I like the idea of auto-refresh on most visuals, but sometimes its useful to have the option no to.

Worked with other BI tools where this is possible.

Re: Refresh visual - manual

ankitpatira — Mon, 25 Jul 2016 09:13:09 GMT

@wvanpeel if i understood you correctly you want to change value in slicers but don't want matrix visual to filter based on selection on slicer, if yes then you can do that easily,

simply highlight slicer visual then click on Visual Tools (top of power bi desktop) -> Edit interactions -> and for matrix visual select None option. This will not let you have no effect on matrix visual when changing values in slicer.

Re: Refresh visual - manual

wvanpeel — Mon, 25 Jul 2016 09:45:36 GMT

Hi Ankit, this is indeed a good tip but still not what I'm looking for.

I'm looking for a way to refresh the data with a delay, by first entering the data in the filters, and then do a refresh of the actual result.

My datasource has many rows and it is refreshing now the data with every click on the slicer(s).

Some other BI tools have this capability.

Re: Refresh visual - manual

lbeneyze — Wed, 17 Jun 2020 11:42:59 GMT

Good afternoon Wvanpeel,

Have you found a solution for this?

Kind regards,

Lohic Beneyzet