Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

sorting stacked column chart power bi

Hi Guys,   I have a stacked bar chart built and it is sorting by the total values(green bar+black bar) descendingly. However, is it possible that I can sort by the only green bar or only black bar ...
Need Help
  • TomMartens's avatar
    TomMartens
    7 years ago

    Hey,

     

    I'm wondering if you have tried the sort options that are available, the screenshot below shows a stacked bar chart and the sorting options ...

     

    In this example, 2 measures are used in the values field of the visualization.

     

    If this doesn't work, can you please create a simple Excel file with sample data, upload the file to onedrive or dropbox, and share the link.

     

    Regards,

    Tom

     

     

     

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
7 years ago

Hey,

 

I'm wondering if you have tried the sort options that are available, the screenshot below shows a stacked bar chart and the sorting options ...

 

In this example, 2 measures are used in the values field of the visualization.

 

If this doesn't work, can you please create a simple Excel file with sample data, upload the file to onedrive or dropbox, and share the link.

 

Regards,

Tom

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi, I am using another field in "Legend" to slice the data so there are two colors there. It looks like you are using two measures here so you can sort that way.

    • TomMartens's avatar
      TomMartens
      Icon for Super User rankSuper User
      7 years ago

      Hey, can you please prepare a little sample data.

       

      Regards,

      Tom