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
jch
Employee
Employee

Sort a Line and Stacked Column Chart by Column values

Is there anyway to sort a Line and Stacked Column Chart so that the Column series with the largest Column values is on the bottom?

 

For example, in the screenshot below, the brown part of the column represents the Column series with the largest Column values.

 

How do I sort the Line and Stacked Column Chart  so that the brown part of the column is at the very bottom

jch_0-1627342295024.png

 

1 ACCEPTED SOLUTION
samdthompson
Memorable Member
Memorable Member

Hello, you would need to give the dimension in the legend part of your visual a sortby: DataView>>>ColumnTools>>>SortBy

 

Whatever the brown one is would be sorted as the first item and on from there.

 

// if this is a solution please mark as such. Kudos always appreciated.

View solution in original post

2 REPLIES 2
samdthompson
Memorable Member
Memorable Member

Hello, you would need to give the dimension in the legend part of your visual a sortby: DataView>>>ColumnTools>>>SortBy

 

Whatever the brown one is would be sorted as the first item and on from there.

 

// if this is a solution please mark as such. Kudos always appreciated.

Hi,

I too have a similar question. Unable to sort the stacked column either in descending or ascending order. There is no sort option available on the visual. Please advise how to sort this data. If possible please provide the screen shots in your response.

Msk_2080_0-1638043107684.png

 

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.