Forum Discussion

shirin's avatar
shirin
Frequent Visitor
4 years ago
Solved

Sort alphabetically or numerically

Hi,
I have a stacked bar chart, by default char is sorted alphabetically . Base on this page https://docs.microsoft.com/en-us/power-bi/consumer/end-user-change-sort#sort-alphabetically-or-numerically  I know what shoud i do if I wants to change from alphabetically to numerical. My Issue is I created Clear Filter button to clean all the filters after applying. Unfortiuntly, it also clean my settings from numerically and I get the chart with sort alphabetically. What should I do to keep my sort numerically setting on my chart?

  • Thanks for the detailed answer, shirin .

    I suspect that the bookmark was created *before* you sorted the visual to your liking.

    Please click on the bookmark, sort the stack bar as it should - and then - click on the update option in the bookmark.

4 Replies

  • Hi shirin,

    Does the clear filter button initiate a bookmark where you cleared all filters?

    Please provide more details if not so please.

    David

  • shirin's avatar
    shirin
    Frequent Visitor

    Hi David,
    I took these steps to create the Clear Filters button : 

    1- Bookmarks --> Add--> Clear Filters ( I put as name) and for more options(...) Data, Display, Current page, All visuals have a check mark. 

    2 - In the Format shape ( I created the button with a rectangle) In Action ---> Type : Bookmark, Bookmark: Clear Filters.

    I hope it can be helpful.

    • David-Ganor's avatar
      David-Ganor
      Resolver II

      Thanks for the detailed answer, shirin .

      I suspect that the bookmark was created *before* you sorted the visual to your liking.

      Please click on the bookmark, sort the stack bar as it should - and then - click on the update option in the bookmark.