Sort by Axis not working in column chart

[Anonymous]

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

[Anonymous]

@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]

@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