Skip to content Skip to sidebar Skip to footer
Home / Chart

Power Bi Change Order Of Stacked Bar Chart

Power BI is a powerful business intelligence tool that allows you to visualize and analyze data in a more meaningful way. One of the most commonly used visualizations in Power BI is the stacked bar chart. This chart is great for comparing data across different categories, but what if you want to change the order of the bars? In this article, we will show you how to do just that.

What is a Stacked Bar Chart?

A stacked bar chart is a visualization that displays data as bars on a chart. The bars are stacked on top of each other, and each bar represents a category. The height of the bar represents the value of the data in that category. This type of chart is useful for comparing data across different categories, and it allows you to see the total value of the data in each category.

Stacked Bar Chart

Changing the Order of the Bars

By default, Power BI will order the bars in a stacked bar chart based on the order of the categories in the data. However, you may want to change the order of the bars to better visualize your data. To change the order of the bars, follow these steps:

  1. Select the stacked bar chart visualization on your report.
  2. Click on the Format tab in the Visualizations pane.
  3. Expand the X-axis section.
  4. Toggle on the Category Order option.
  5. Click on the dropdown arrow next to Category Order and select the field that you want to use to order the bars.

Once you have selected the field to order the bars, Power BI will reorder the bars based on the values in that field. You can also use the Ascending and Descending buttons to change the order of the bars.

Changing The Order Of The Bars

Sorting the Data

Another way to change the order of the bars is to sort the data in the data model. To do this, follow these steps:

  1. Open the data model by clicking on the Data view button in the left navigation pane.
  2. Click on the table that contains the data for the stacked bar chart.
  3. Click on the column that you want to use to order the bars.
  4. Click on the Sort ascending or Sort descending button in the ribbon.

Once you have sorted the data, the bars in the stacked bar chart will be ordered based on the sorted data.

Sorting The Data

Conclusion

Changing the order of the bars in a stacked bar chart in Power BI is a simple process that can greatly improve the visual representation of your data. Whether you choose to use the Category Order option or sort the data in the data model, you can easily reorder the bars to better visualize your data. By following these steps, you can create more effective visualizations and gain deeper insights into your data.

Related video of Power BI Change Order of Stacked Bar Chart

You may like these posts :