Forum Discussion

Johnsnowlife's avatar
Johnsnowlife
Icon for Helper III rankHelper III
9 years ago

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...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago

Hi Johnsnowlife,

 

In the visual select on the top right corner the "..." and select the sort order in the chart.

 

Regards,

MFelix

Johnsnowlife's avatar
Johnsnowlife
Icon for Helper III rankHelper III
9 years ago

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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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

    • Johnsnowlife's avatar
      Johnsnowlife
      Icon for Helper III rankHelper III
      9 years ago

      That doesn't work. I get the error mentioned in the first post.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        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