Forum Discussion
Custom Sort Stacked Column Chart on Two Fields
PBI file attached. I switched the visual to a Table. Sorted by the first column in ascending order and the last column in descending order. Switched the visual back to the original one.
Hope this helps.
Thank you for your reply. Unfortunately, that is not what I need. If i do that, the Regions (colors) are no longer grouped together.
I need the Branches sorted by descending order within their respective Region (or Color) groups, like this:
Thanks again,
Anonymous
can you please share sample data ?
Hmm...it seems I cannot attach an excel file or a pbix file. I don't want to add work on your end but recreating the below image should get you the information you need to solve the problem.
Upload the file to Google Drive or a similar file hosting service and share the download link.