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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Sort by Axis not working in column chart

I have a stacked column chart which is showing a sum of deal value on the Y axis and firm names on the X axis, I would like to be able to sort the visual by deal value in descending order, and I have selected this in the "Sort by Axis" option of the visual, but this doesn't do anything to sort the visual. I can sort by firm name just fine but I cannot sort by deal value.

 

chart.jpg

 

This is what my data model looks like, with firm name coming from the "vwFirmProfile" table and deal value coming from the "vwDealInfo" table, both of these tables are related to the "vwPortfolioDealMap" table, not sure if this has anything to do with my sorting issue. Has anyone come across this issue before or has any idea on how I could fix it? Thanks

 

model.jpg

 

2 REPLIES 2
Anonymous
Not applicable

@amitchandak, Thanks for your response, yeah that is exactly what I have done as shown in the screenshot, but it isn't working for me.

amitchandak
Super User
Super User

@Anonymous , In Sort Axis, I can see an option for deal value, Is that not working? Sort on deal value and sort descending. On legend, you will not get an option for deal value

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

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