How to sort stacked column chart by data value

[PBI_newuser]

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

[APavlovs]

Hi @PBI_newuser ,

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 🙂

[PBI_newuser]

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

[APavlovs]

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

[mahoneypat]

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

Pat

[PBI_newuser]

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?

[mahoneypat]

I don't think you can do that with the Ribbon Chart, but this visual could be built pretty easily with the Charticulator visual.

(15) Austin Power BI User Group - Charticulator 101 - YouTube

Pat