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
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
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.