Forum Discussion
Sorting stacks in a Stacked Bar Chart
My data represents holdings of specific instruments in different funds and their market value and realised gain. I am trying to sort the below chart by the total size of the bar descending. Can you p...
Hi Johnsnowlife,
In the visual select on the top right corner the "..." and select the sort order in the chart.
Regards,
MFelix
That only allows me the option of sorting by the "Code" or any of the Stack values. But i want to sort by the total value of all the stacks.
Hi Johnsnowlife,
You can try to use sort by column function.(it support use other column to sort chart)
Reference:
Sort by column in Power BI Desktop
Regards,
Xiaoxin Sheng
That doesn't work. I get the error mentioned in the first post.
Hi Johnsnowlife,
It seems like the sort by column function not works on summary values.
Perhaps you can add column to calculate the total, then use it as the sort column.
Regards,
Xiaoxin Sheng