cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
andres6and8
Frequent Visitor

How can I remove the sorting "carrot" symbol in the "matrix" visual?

Hello, is there a way to remove the sorting symbols from the column headers?

 

I'm referring to the carrot symbol shown below:

 

example_PBI.PNG


Thanks in advance. 

5 REPLIES 5
annadeak
New Member

In Power BI Desktop, I found that if I remove the sorted field from the "Rows" area in the Visualization data, and then put the field back in the "Rows" area, the little sort indicator will disappear.  

czak
Frequent Visitor

Thank you annadeak!  Removing and adding back into Rows did work in the matrix visual.  After publishing, the sort arrow was not visible either.  Thank you for sharing!

v-ljerr-msft
Microsoft
Microsoft

Hi @andres6and8,

 

Currently, there is no option to remove the sorting symbols from the column headers. You can add it as an idea on Power BI Ideas to improve Power BI on this feature. Smiley Happy

 

Regards

malagari
Responsive Resident
Responsive Resident

I haven't seen a way to turn this off unfortunately.

Dan Malagari
Consultant at Headspring

You cant turn that off, but a possible workaround is to create a calc column that provides the desired ranking/order and then sort your field by this calc column.  Of course, a user won't be able to change that the way the carrot allows for quick changing of ascending/descending order.

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors