Stacked Column Chart sort

[jdavison]

Hi All, 

I am using a stacked column chart with two fields on the x axis. The first field forms 'buckets' for the x-axis and the second is the individual columns.

However, I want to sort by the count, but when i do this it sorts on individual count from the second field rather than total count from the first field, is there a way to keep the categories from the first field intact just sorted by total count?

Thanks

[v-hjannapu]

Hi @jdavison,

Thank you  for reaching out to the Microsoft fabric community forum.
Thank you @amitchandak, for your reply regarding the issue.
I hope the information provided by @amitchandak  assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Regards,
Harshitha.

[v-hjannapu]

Hi @jdavison,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Regards,
Harshitha.

[v-hjannapu]

Hi @jdavison,

I wanted to follow up and see if you have had a chance to review the information that was shared. If you have any additional questions or need further clarification, please don’t hesitate to reach out. I am here to assist with any concerns you might have.

Regards,
Harshitha.

[amitchandak · Accepted solution]

@jdavison , Not when you use it as a second column, but if you use that as legend then you can do that using Column -> Layout -> Sort by Value