Forum Discussion

wvanpeel's avatar
wvanpeel
Advocate II
10 years ago

Refresh visual - manual

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)...
ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

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.

  • wvanpeel's avatar
    wvanpeel
    Advocate II
    10 years ago

    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.

    • lbeneyze's avatar
      lbeneyze
      Advocate II
      6 years ago

      Good afternoon Wvanpeel,

       

      Have you found a solution for this?

       

      Kind regards,

      Lohic Beneyzet