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.
Hi,
Click on the 3 dots at the upper right hand side of the visual and sort by the measure in descending order.
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.
