Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
We created a nice dashboard in our company following all of the rules of the star schema. Everything works great except that every time we make changes to pbix file and publish the report again (overwriting previous version) both numbers and the look of the slicers in the published report onilne gets messed up.
Clicking on "reset to default" helps but why would it be needed every time? Our users are almost required to click on "reset to default" every time they open the report, otherwise they can't trust the numbers.
Is there a specific known mistake in the way the report is created that is causing this?
Thanks
Hi @PshemekFLK
Yeah I can appreciate that. Currently that is the way it is unfortunately.
You could look for an idea at https://ideas.powerbi.com to vote for.
Hi @PshemekFLK
The reason is that the filters are applied to each user. And those are kept even when a new version of the report is updated. What you are doing is 100% correct.
If there are not frequent updates to the reports, then this should be ok. And it is good for users to be able to keep their filters and slicers for their own reports.
To be honest users are annoyed with the fact that they have to "reset to default" every time. We do a lot of changes to the report as this is what the organisation requires. Users create bookmarks to keep their filters. There should be at least the possibility to turn off the automatic user filters if that would fix the issue.
User | Count |
---|---|
35 | |
32 | |
21 | |
11 | |
8 |
User | Count |
---|---|
54 | |
43 | |
28 | |
13 | |
11 |