How to Flip a Stacked Bar Chart in Power BI

Trying to flip a stacked bar chart in Power BI often feels like it should be a one-click checkbox, but it's not always that straightforward. The term "flip" can mean different things to different people - changing horizontal to vertical, reversing the order of the bars, or even inverting how the stacks themselves are arranged. This guide will walk you through all of these scenarios step-by-step so you can get your chart looking exactly the way you want it.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

What Does "Flipping" a Stacked Bar Chart Mean?

Before diving into formatting menus, let's clarify the most common goals users have when they want to "flip" a chart. Depending on your needs, you might be trying to accomplish one of four different things:

• Flip from Horizontal to Vertical: This is the most common goal. You have a horizontal stacked bar chart and want to turn it into a vertical stacked column chart.
• Flip the Sort Order of the Bars: You want to reverse the order of the categories along the Y-axis. For example, instead of displaying regions A, B, and C from top to bottom, you want them ordered C, B, A.
• Flip the Order of the Segments (Legend): You want to change the stacking order of the colored segments within each bar. For instance, you want your "High Priority" segment at the bottom of the stack instead of the top.
• Flip the Entire Chart Upside Down: You want the bars to extend downwards from the top of the axis instead of growing upwards from the bottom.

We'll cover how to master each of these transformations below.

Method 1: The Easiest Flip - Horizontal Bar to Vertical Column Chart

This is the simplest flip and, fortunately, the one most people are looking for. Power BI considers horizontal bars and vertical columns to be two distinct chart types. Swapping between them is incredibly easy.

Let's say you started with a Stacked Bar Chart like this, showing product sales across different regions.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step-by-Step Instructions:

1. Select your chart: Click on your existing Stacked Bar Chart on the Power BI report canvas to select it.
2. Locate the Visualizations pane: This is the panel on the right-hand side of the Power BI interface where you build and format visuals.
3. Choose the Stacked Column Chart icon: In the grid of available chart types, simply click on the Stacked Column Chart icon. It looks like a vertical bar chart.

That's it! Power BI will instantly convert your visual. Your fields will automatically be reassigned to the appropriate axes. What was on the Y-axis (e.g., Region) will move to the X-axis, and your values will now be represented by vertical height instead of horizontal length.

Method 2: Flip the Sort Order of the Bars/Columns

Sometimes, the "flip" you need is really a reversal of the sort order. By default, Power BI often sorts category labels alphabetically. If you want to order them differently - either alphabetically descending or based on their total value - you can do so directly from the chart.

Step-by-Step Instructions:

1. Select your visual: Click on the stacked chart you want to reorder.
2. Open the 'More options' menu: Hover your mouse over the top-right corner of the visual to reveal the menu options. Click the ellipsis (...).
3. Navigate to 'Sort axis': In the dropdown menu, hover over 'Sort axis'.
4. Choose your sort criteria: You will see a few options:

Simply select Sort descending to reverse the current order. This gives you direct control over how your categories are presented, helping guide your audience's focus to the most important data points first.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Method 3: Flip the Order of the Segments in Each Bar (The Legend)

This one is more advanced and solves a common source of frustration. Imagine you have a legend describing priority levels: 'High', 'Medium', and 'Low'. By default, Power BI will sort these legend items alphabetically, resulting in 'High', 'Low', 'Medium' - which doesn't make logical sense.

You want to define a specific, logical order for the stacks. To do this, you need to use the Sort by Column feature in the Data view.

Step-by-Step Instructions:

1. Navigate to the 'Data' view: On the left side of the Power BI window, click the grid icon to switch from the Report view to the Data view.
2. Select the source table: In the 'Fields' pane on the right, find and select the table that contains the data for your legend (e.g., your 'Tickets' table with the 'Priority' column).
3. Create a sort order column: With your table selected, go to the Table tools or Column tools tab at the top and click on New column. We are creating a helper column that assigns a number to each category to define its order.
4. Write a simple DAX formula: In the formula bar, use a SWITCH or nested IF statement to create your sort logic. For example:

This formula creates a new column named 'Priority Sort Order'. It assigns the number 1 to 'High', 2 to 'Medium', and so on. Press Enter to create the column.

1. Select the legend column to be sorted: Now, click on the original column header for the data you want to sort (in our example, the 'Priority' column).
2. Apply the 'Sort by Column' feature: With the 'Priority' column selected, click on the Sort by Column tool in the Column tools ribbon at the top of the screen. A dropdown will appear listing all other columns in your table.
3. Choose your new sort order column: From the dropdown, select the helper column you just created ('Priority Sort Order').

Once you complete these steps, Power BI uses the helper column's order to arrange the legend segments logically: High, then Medium, then Low.

Method 4: Invert the Y-Axis to Flip the Chart Upside Down

Finally, another way to "flip" a chart is to make it render from top to bottom. This inversion is purely a formatting change and can be useful for visualizations that represent rankings, depth, or anything where being at the "top" of the chart corresponds to a lower numerical rank.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step-by-Step Instructions:

1. Select your visual: Click on your stacked chart.
2. Open the 'Format your visual' pane: Click the paintbrush icon in the Visualizations pane.
3. Navigate to the axis settings:
4. Expand the 'Range' options: Inside the Y-axis settings group, find and click on Range.
5. Toggle on 'Invert range': Click the slider next to 'Invert range' to turn it on.

Your chart will immediately redraw itself. For a horizontal bar chart, the categories will be ordered from bottom to top, with the bars extending right. For a column chart, the X-axis moves to the top, and the columns grow downwards.

Final Thoughts

While Power BI doesn't have a single "flip chart" button, it gives you complete control over every aspect of your visual's orientation and order. Whether you need to swap from horizontal bars to vertical columns, reverse the sort order of your categories, define a custom legend sequence, or invert an entire axis, you now have the tools to do it effectively.

Mastering these details is what separates a decent report from a great one, but we know it can feel like a lot of clicking through menus to get it right. At Graphed, we handle this formatting work for you automatically. You can just ask us to "Show me last quarter's sales by product line as a column chart, with the highest sales on the left," and we’ll instantly generate a live, real-time dashboard that looks exactly as you described, no manual tweaking necessary.