Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
@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.
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.
Good afternoon Wvanpeel,
Have you found a solution for this?
Kind regards,
Lohic Beneyzet
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
2 |
User | Count |
---|---|
8 | |
6 | |
4 | |
4 | |
4 |