Power BI - Custom Sorting in 3 Easy Steps!

Hey guys! Parker here. Check out this quick Power BI tutorial on how to set a custom sort order for your charts, legends, or values! This is extremely easy to do in Power BI and definitely something you should add to your toolbelt!

Enroll in my introductory or advanced Power BI courses:

Elite Power BI Consulting:

Data Insights Tools:

Connect with me on Twitter!

[VengerVideoGamer]

Why the hell does everything in Power BI have to be so awkward? Especially when it's so simple in Excel? Almost as user-unfriendly as Word.

[dlinnoedlinnoe]

No, sorry, that didn't work. And 'Sorting' in the toolbar didn't appear for my column.

[chrissyvoso]

This was SO helpful - I don't think I would have ever figured this out on my own. Thank you!

[ericet]

I view this video all the time because doing this is always simple and not so easy at the same time. But CAN YOU MAKE A 2023 VERSION PLEASE ? PBI has changed so much and it’s hard to do this trick with the current version.

[NatashaRidley]

Totally agree with Roger Vincent, this is the simplest and quickest solution - so easy to follow after watching some other confusing longer videos and getting no where. My graphs are now custom sorted and so easy to do in the future - thanks so much BI Elite !

[RogerVincent-lbqh]

OMG! I looked at, at least a dozen other 'solutions' and this was by far the simplest and BEST explanation. Kudos and great job on making it so clear and easy to understand!!!

[manojmicro]

How to add a new row to already created table in SortOrder?

[reemanaz]

Thank you!! Short and to the point without pointless talking or introductions

[litimeadam]

Thanks, but why is not working with all data in my column?

[alexism]

Best tutorial I have found regarding this issue to date! Excellent.

[max]

Thanks, clear explanation. However, to prevent uncontrolled growth and complexity of tables, I would advise to merge the two tables!

[gtobw]

Thanks for awesome trick, could I also apply this to donut chart?

[TracyOsimowicz]

The Modeling tab disappears when I click on Table view

[Hofstad]

When i click on my column to bring up "Modeling", Modeling does not even come up as an option to click on. Nor a "Sort By' option.

[schajuli]

Really thank you! I just don't get it why you need a second table to achieve that. Why can't I just add a new order column to my initial table and sort by that values. So annyoing.

[gaMEXDavid]

Nice video, I am working on a dashboard that is live connected to a dataset, so the data view is not available 😔

[mocafrappalatte]

Thank you so much! It took me forever to find a video for sorting the order of the columns rather than the content of the columns. Very easy to follow video!

[germantejeria]

Hi, I tried this with a matrix, and it did not work as expected. For charts it's ok, do you know if there is another way?

[eduardoteixeirajj]

Thanks! I've realized how creating these little dimension tables really help work around little things like this😀

[danghill]

Thank you. This is exactly what I was looking for! Such a simple solution.