Forum Discussion
Power BI table set default column sort
I have a table visual in Power BI. It is intentended to show the products most sold over the period. Whenever anyone first opens the report in the PBI service, the sort order should always be on the amount sold column (descending). I don't mind if the user changes the sort order from then on. But if they choose to sort the report by a different order (or use ascending on the amount sold column) and then exit the report, I want the report to open up with the amount sold (descending) as the sort order for the table the next time they open the report.
I haven't found a way to do this in Power BI Desktop or editing in the Service. What am I missing?
Russ Loski
Good question. You can perhaps create a bookmark only for the table. Than they have to reset via a button the table. The ppl open the report, have their last slicer selections. And they reset with the button the matrix
7 Replies
You have to prevent them to save their own "view". First point persistent filter:
andhiii079845 Thank you for your reply. Your approach does indeed return the report to use the original sort order. At the same time, it returns all of the slicer selections to the original values.
I am going to leave this open for a little longer
By the way, I wasn't expecting any answer to this question. Your answer was far more than I expected.
Cheers,
RussSecond idea:
Navigate the ppl to a bookmark link and this bookmark effect only the matrix and reset it?
"You have to prevent them to save their own "view". First point persistent filter:"
??? The word 'View' does not appear in this list. What is a First Point persistent filter?
What is your advice here?
Hello rloski-public ,
the thing is everyone has the filters he applied saved whenever he opens the dashboard from his user, unless he reset filters then it would be as you mentioned.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote for my Community Mobile App Idea 💡Good question. You can perhaps create a bookmark only for the table. Than they have to reset via a button the table. The ppl open the report, have their last slicer selections. And they reset with the button the matrix
This approach worked the best, I think (waiting for user approval).
I created a bookmark with the table selected. I set the Data and Display, and Selected Visuals. I tried to leave Data out and it didn't work. I haven't experimented leaving Display off.
The user can reset the order to the expected order by clicking a button that has the action to run the bookmark.
Thank you very much.Cheers,
Russ
