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 here?

 

Thanks,

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

     

     

     

3 Replies

  • 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