Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to sort stacked column chart by data value

Hi, is it possible to arrange the stacks in the bar graph from largest to smallest?

 

7 Replies

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee

    Try using a Ribbon Chart instead.  It's one of the other options in the visualizations pane.

     

    Pat

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi mahoneypat , thanks for your suggestion. It works on Ribbon chart but there is no total label options on the format pane. Do you have any idea how to show the total count on top of the bar?

       

  • Hi Anonymous ,

     

    You can change the visual sort under the ellipsis in the top right of the visual.

     

     

    Did I answer your question? Mark my post as a solution ğŸ™‚ If I gave you an idea on how to solve this otherwise give my post some Kudos ğŸ™‚

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi APavlovs , if sort by value, the date is not sorting in ascending order.

      • APavlovs's avatar
        APavlovs
        Icon for Resolver II rankResolver II

        Yeah missed that part 🙂 focused on the first issue I saw.