Share this article
Improve this guide
How To Remove The Sort Arrow In Power BI [Step-By-Step]
Learn to disable sorting in a few moves
2 min. read
Updated onOctober 4, 2023
updated onOctober 4, 2023
Share this article
Improve this guide
Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more
Key notes
We all know sorting yourdatais great and extremely necessary. InPower BI, the sorting function is complex and you can sort your data using different criteria.
Nevertheless, sometimes you need to do quite the opposite and to disable sorting for your information.
Unfortunately, disabling sorting inPower BIis not so obvious as it should have been, but do not worry! We have some workarounds just for you!
Also, you’re not the only one with this problem. Actually, many users complained that they can’t disable sorting in Power BI.
One user said the following onthe official forum:
Hi, how it possible cancel ordered column in table in Power BI? Once I sort the column, I can’t cancel it anymore.
So, this user said that he can’t cancel a sorting once it’s enabled for columns in a table in Power BI. Today we will show you how to disable sorting in a few easy steps.
How can I remove the sort arrow in Power BI?
1. Disable sorting from Data visual
You can do this only for the second column. For the first one, even if you clear sorting, the ordering will remain the same.
2. Disable sorting from Table visual
If you want to sort inTable visual, then you need to clickSortagain.
3. Create another column
You can create a calc column to enable the desired ranking. This is not an actual random order, but it is a workaround that quite a few people use.
Remember that these are only workarounds, andPower BIdoesn’t have an option to disable the ordering. So, the methods described above might not work for everyone.
This is not a major issue, but still, it is annoying to see that you can’t sort yourdatalike you want to. AlthoughPower BIis great in many ways, thetoolhas some limits.
Did you find our workarounds useful? how to you sort yourdatainPower BI? Do let us know in the comments section below!
Milan Stanojevic
Windows Toubleshooting Expert
Milan has been enthusiastic about technology ever since his childhood days, and this led him to take interest in all PC-related technologies. He’s a PC enthusiast and he spends most of his time learning about computers and technology.
Before joining WindowsReport, he worked as a front-end web developer. Now, he’s one of the Troubleshooting experts in our worldwide team, specializing in Windows errors & software issues.
User forum
0 messages
Sort by:LatestOldestMost Votes
Comment*
Name*
Email*
Commenting as.Not you?
Save information for future comments
Comment
Δ
Milan Stanojevic
Windows Toubleshooting Expert
Before joining WindowsReport, he worked as a front-end web developer. Now, he’s specialized in Windows errors & software issues.
