Table visualization - remove sort arrow?

[DLB13]

Hi all - 

Quick question. Is there any way to remove the sort ascending/descending arrow from the table visualization? Thank you in advance!

[maxd]

Table > Ellipsis (three dots at top right) > Sort by > untick the column with a tick

[LotteLaugesen]

Add another column to the table. Sort the new column. Remove the new column.

And puff the arrow has gone 😉

[B3ngt]

Thank you, I want the option to turn off this sort by clicking on header, but this did the trick.

[Daviejoe]

Hi

I had to create a table, that the user didn't want have a sort function, so without thinking too much about it I placed a see through shape over the top of the table headers so the users were unable to sort it.

[negi007]

@DLB13 You can achieve this by creating a seperate table to sort your data. In this table, you can have two columns, first column by which you want to sort values and second column a sequence number. Once you have created the table, then link it to your main data table. Under the Column Tools, you will get option to sort your values. Now in your table, you can sort values without sort arrow appearing.

[Tahreem24]

@DLB13 ,

If you mean to say sorting order like below image so I doubt there is no control over it.

[DLB13]

yes, that's what I mean... bummer!

[Tahreem24 · Accepted solution]

@DLB13 ,

If You really wanna get rid of this sorting arrow of Table visual so do one workaround like below screen shot.

I took Shape on top of Table visuals and it will not allow hovering so your sorting order will be gone 😉.

Try to change the shape border color to white to make it hidden.

[Daviejoe]

Ha, you beat me too it.  Sometimes the simplest solutions work perfectly well 😀

[Tahreem24]

@Daviejoe ,

If my post helped you so please mark it as a solution so other may take help from it.

Good Luck!

[negi007]

@DLB13 

Below articles can help you in doing sort by column:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column

https://radacad.com/sort-a-column-with-a-custom-order-in-power-bi