Forum Discussion
Power BI Service persists old sort by value in Reading view
Power BI Service keeps reapplying an old “Sort by value” in Reading view, even after:
- correct Sort by column in the Table view
- explicit sort by Year in the visual in Desktop
- overwrite publish from Desktop
Even in Edit mode it can be changed to the correct order. But Reading view immediately snaps back.
What is happening?
Is there any way to clear this without deleting the report and uploading again? (This would change the URL which I would have to replace in like 30 places)
Any advice is appreciated
It happend because of the persistent filters you have. Click the reset button top right of the report to return your report to the default published state.
But this will fix only your point of view, if others struggle with the same issue you could enable persistent filters from the reports setting. If you enable this, the reports will always be open with the default saved state for all users.
5 Replies
- MasonMA
Super User
This worked. Thank you. I saw the button maybe a hundred times, but didn't use it, because I felt, this was no change that I made in the online version, hence nothing to reset.
- cengizhanarslan
It happend because of the persistent filters you have. Click the reset button top right of the report to return your report to the default published state.
But this will fix only your point of view, if others struggle with the same issue you could enable persistent filters from the reports setting. If you enable this, the reports will always be open with the default saved state for all users.
Thank you so much. This fixed it. Where exactly can I find the settings for "Persistent filters"?
- AnkitKukreja
Hi! DiligentPBIUser
I would advise to clear all the cache and history of Power BI and try. Not a full proof solution but might work. Also, if this doesn't work please try to publish this in another workspace as a new report and check the behavior there and if this resolves your issue, then you might have to delete your report and republish it.
