How to add a SIMPLE SORT BUTTON // Switch to Asc or Desc, Change Sort By // Power BI Guide in 2023

In this video were going to look at how you can create a simple sort button that lets you change the sorting order of your tables in Power BI. For a more complex solution, we also cover how you can change which category its sorting by.

🕓 TIMESTAMPS
0:00 - Intro
02:37 - Setting up the buttons
04:32 - Creating the ranking DAX measure
08:01 - Changing which measure to sort by

-

📣 Get Demo Files HERE

🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required.

📰 Sign up to our FREE Weekly Newsletter for Power BI news, community updates and more

🛒 Power BI TEMPLATES and more at our digital shop

❤ Other ways to SUPPORT us

📧 GET IN TOUCH

🤝 SOLUTIONS ABROAD
Hi Power BI fans, my name is Fernan. In 2018 I founded Solutions Abroad to help fellow data enthusiasts learn Microsoft’s tool, Power BI. I’m currently based in London with over 8 years of experience working with data and business intelligence. In this channel I provide educational videos about Power BI including tips and tricks, step by step tutorials, news, and all of it for FREE. I also provide some paid content such as courses, templates as well as consultancy services.
If you like what we’re doing here and would like to support, consider purchasing something or donating through our Patreon, every little penny helps us keep the channel going.

🙏 THANK YOU
Thank you so much for checking out my channel and my videos. You, the community, have been instrumental in growing the channel to where it is now. Hope to see you again on my next video!

#PowerBI #DataAnalytics #BusinessIntelligence

[lightbult]

only 2min in and i already like this video. I love that u show the end result at the very beginning

[hichamezznati]

thanks a lot for this amazing video and trick.
here is an other way to have the same result .
table for sorting order :
Table = {(1, "△"), (-1, "▽")} with respectively 2 colums : C1, C2
if we note SM the selected one among the 03 measures
the ranking is =
SELECTEDVALUE(Table[C1])*
RANK(dense, ALLSELECTED(Categories[categoriesname], ORDERBY([SM], ASC))

[akshaykodekal]

Your informative videos are amazing and I love watching them.

[JoseOmarSanchezAvila]

Genius! Thank you, i haven't found a similar solution so far

[svetlanaspitsyna]

Is it possible to sort data by two columns in two steps? For example, I have a matrix with categories and sales, and in rows below categories I have months, so I want to sort categories by volume, but when I press + on a category I want to see months in chronological order, but I see them sorted also by volume.

[lpytkkr]

Amazing video ! Thanks for sharing it.
How we can apply this solution to a field parameter table allowing to switch between different dimensions.

[krishraj]

thanks, can it be extended with multiple columns and to other visuals like matrix and any small multiples - where we have a lot of limitations with sorting within a group?

[sumeshkumar]

Perfect! But in my case its a matrix with double column headers . Eg: Order, Sales, unit price (for last week & last month as its separated my headers (last week & last month) . So instead of creating 3 measures it will have +3 measures more? Any idea on custom sort for this type of scenario?

[gauravguliani]

At 1:30 in Intro the default solution of shift by 2nd column selection to sort- works only for Table visuals
Not for Matrix ones

[dmitriyivanov]

Good afternoon. I would also close the table with an invisible picture so that the user would not be able to sort by another column.

[htctihp]

I have a doubt for one scenario. Please let me know if you have any idea.customized tooltip not showing for total when hover in mtraix visual

[perfectionist]

Can we do this with existing columns.

I don't have measures in table.
Please help

[htctihp]

How could we get the keyboard for the adding the icons

[gauravguliani]

Also your solution did not show if it works when we select multiple columns