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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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.




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




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.

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

Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.