# Tableau Tip: How to Sort Stacked Bars by Multiple Dimensions

02 Set, 2016

Note: The following is a guest post by Tableau enthusiast Matt Chambers.

For Makeover Monday, I wanted to tell the story of how Facebook is making an effort to make clean and renewable power its primary source of energy. I wanted to be able to sort the stacked bars by energy usage percentage by year. Here's how it's done:

1. Build your stacked bar chart in Tableau.

2. Create a combined field using the dimensions you want to sort by. In this case, I want to sort by energy source by year.

3. Drag the combined field to the detail and sort by the measure. Here, I am sorting by Amount.

4. Finally, drag the dimension that you are sorting by to the detail. I am using Energy Source in this example.

5. Now you have a stacked bar that is sorted by two dimensions. In my example, it is sorted by energy source and date. This allows for some nice interactivity that allows you to show trends and magnitude simultaneously. In my example, I am using it to show the rank of the energy sources while also showing the magnitude against other energy sources.

For more tips, tricks, and vizzes by Matt, check out his Tableau Public profile page and his blog. You can also connect with him on Twitter @sirvizalot.

## Comentários

Submitted by Cliff Beiser (não verificado) on

Looking forward to using this tip! Thank you

Submitted by Elavar sevvel (não verificado) on

Wow. It is really amazing. Can you please explain me the technical stuff behind it. How creating a combined field and placing the energy source in detail worked out ?. Thanks for sharing it.

This is great! Like Elavar, I am struggling to understand why the sequence of steps that you mentioned had to happen for this to work. Would you be able to elaborate please?

Thanks

Submitted by Pat (não verificado) on

Does this technique require Tableau 10?

Submitted by Kurnia (não verificado) on

Nope, earlier versions also have create >> combined field menu

Brilliant, thanks for your tip. I will definitely use this.

Submitted by John S. on

On Step 4, for this example why does the Energy dimension need to be put on the detail shelf? It is already on the color shelf, so it already defines the level of detail. Perhaps it is a best coding practice in case color is used for something else?

Submitted by Matt Chambers (não verificado) on

It's because I didn't have Energy Source as an attribute on the color shelf. If you change it to an attribute, you can take Energy Source off of the level of detail.