cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Partisan
Post Partisan

how to remove Sorting arrow in power bi.

Hi All,

 

Need help I don't want sorting arrow in the column header. How can I hide or vanish from the table?

 

Regards,

Arvind

7 REPLIES 7
Highlighted
Community Support
Community Support

Re: how to remove Sorting arrow in power bi.

Hi @arvindyadav,

 

Current power bi seems not support this. I'd like to suggest you submit this to ideas forum.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
New Member

Re: how to remove Sorting arrow in power bi.

have you figured it out? I have exact the same issue. 

Highlighted
Advocate I
Advocate I

Re: how to remove Sorting arrow in power bi.

There is a workaround you can do, add a blank button(with 0 outline and no fill) on the top of column headers. Bring that button to forward (in format pane) and send back the table backwards (in format pane).

 

cons: If user selects any value from table, it will become clickable because table will come to focus and button will go back unless focus is released.

 

Depends on how report will be used.

Highlighted
Continued Contributor
Continued Contributor

Re: how to remove Sorting arrow in power bi.

You'd like it to never appear; or now that it has appeared, you can't get it to go away?

 

If you can't get it to go away, just remove and re-add the column to the table visual.

Highlighted
Anonymous
Not applicable

Re: how to remove Sorting arrow in power bi.

This should be Power BI's slogan haha

Highlighted
Frequent Visitor

Re: how to remove Sorting arrow in power bi.

I have a work around for this. Hope it helps some people. It's a little extra effort and might not work if you need to adjust the width of your table columns often.

 

If you have a fairly static width then to hide the arrows you can do as follows:

1) Obviously first you need to Rank/sort the column that you want.

2) Make the table header backgroud and the table header text the same color as the backdrop of the whole report so everything blends in.

3) Insert as many text boxes as column headers and duplicate the column names in the text boxes you just created. Make sure the text boxes span the entire width of the columns and it covers the arrows in each column. When someone goes to try to sort the columns they will instead find themselves clicking on text boxes and nothing will happen to the sort order of the Table.

 

 

Highlighted
Advocate I
Advocate I

Re: how to remove Sorting arrow in power bi.

@Bootkie2  That's already been suggested  a few posts above. You should delete your post.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors