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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

Top Solution Authors