Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
gac550
New Member

How Customize Filter Sort Order in Power BI 2.96 or Higher?

Hello, I got very frustrated trying to use a specific order in my filters and stacked bar graphs. In the latest version of Power BI (2.96.xx.xx) doesn't have the button to order by a specific column.

 

gac550_0-1629292368274.png

 

For example, I'm trying to order a filter by "Sort Order" but isn't working (I don't want to sort by Capital, or alphabetical).

 

CapitalSort Order
Arica1
Santiago2
Concepción5
Chillán3
Ñuble4

 

Many thank's in advance.

 

gac550_1-1629292602435.png

 

 

1 ACCEPTED SOLUTION
m3tr01d
Continued Contributor
Continued Contributor

Hello @gac550 ,

you need to go in the Data view 

m3tr01d_0-1629293655608.png

Select your column then go to Column option

m3tr01d_1-1629293685106.png

 

View solution in original post

2 REPLIES 2
m3tr01d
Continued Contributor
Continued Contributor

Hello @gac550 ,

you need to go in the Data view 

m3tr01d_0-1629293655608.png

Select your column then go to Column option

m3tr01d_1-1629293685106.png

 

Hi, you are right, how I solved was to unlink the related tables, set the sort order in DATA / VIEW / TABLE (must be totally unlinked), and then link the table again, which was the only way.

Many thanks!

Gonzalo

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.