How to Increase Bar Size in Power BI

Nothing is more frustrating than building a Power BI bar chart only to find the bars are pencil-thin, with huge gaps between them. This common issue can make your reports look unprofessional and hard to read. This tutorial will walk you through the simple settings you can change to increase bar size, control spacing, and make your charts clear and visually impactful.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Does Bar Size Matter in Power BI?

Before diving into the "how," it's helpful to understand the "why." Adjusting the width of bars in your charts isn't just about appearances, it significantly affects how your audience interprets the data. The default settings in Power BI are a starting point, but refining them is what separates a decent report from a great one.

Here’s why taking a moment to tweak your bar sizes is worth the effort:

• Improved Readability: Wider bars are simply easier to see, especially on smaller screens or when the report is printed. They create a stronger visual anchor for the eye, making it effortless for viewers to compare values between categories.
• Better Visual Impact: Thin, spaced-out bars can make your data look sparse or insignificant. Bolder, thicker bars command more attention and give your data the visual weight it deserves, guiding your audience to the key insights you're presenting.
• More Professional Polish: Customizing elements like bar width shows an attention to detail that elevates your work. It moves your report away from a "default" look and gives it a bespoke, polished feel that builds confidence in your analysis.
• Enhanced Data Density: In charts with many categories, managing the relationship between bar width and the space between them becomes even more critical. Proper spacing prevents a chart from looking either too cluttered or too empty.

In short, well-proportioned bars are a cornerstone of effective data visualization. Let's look at the easiest way to control them.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The Main Method: Adjusting Inner Padding in the Format Pane

The most direct way to control the width of your bars in both bar charts and column charts is by using a setting called Inner Padding. The name can be a little confusing at first - you might expect to find a setting called "Bar Width" or "Size" - but once you understand how it works, it becomes second nature.

Inner Padding controls the amount of empty space between the bars in your chart. Think of it as the buffer zone separating each category. Here's the key takeaway: to make your bars wider, you need to decrease the inner padding.

Step-by-Step Guide to Changing Inner Padding

Follow these simple steps to find and adjust this setting:

1. Select Your Chart: Click on the bar or column chart visual you want to edit on your Power BI report canvas. A border with resize handles will appear around it, and the Visualizations pane will update to show its settings.
2. Open the Format Pane: In the Visualizations pane, click the paintbrush icon to switch to the "Format visual" tab. This is where you can change all the styling and formatting options for your chart.
3. Find the Bar Settings: Depending on your chart's orientation, you'll need to expand either the Columns (for vertical charts) or Bars (for horizontal charts) section.
4. Locate the Spacing Menu: Inside the Columns or Bars section, you’ll see another sub-section called Spacing. Click to expand it.
5. Adjust the Inner Padding: Here you will find the Inner Padding slider and input box. The default is typically set to 20%. To make your bars wider, simply slide the slider to the left or type a smaller number into the box next to it.

For example, if you change the Inner Padding from 20% to 5%, you’ll instantly see the bars become much thicker, filling more of the available space. If you set it all the way to 0%, the bars will touch each other, which can be useful for creating histograms or when you want to show a continuous distribution.

Tips for Using Inner Padding Effectively

• Don't Go Overboard: While wider is often better, completely eliminating the space between bars can sometimes make it harder to distinguish between individual categories. A small amount of padding (e.g., 5-10%) usually provides a good balance between visual impact and clarity.
• Consider Your Category Count: For a chart with only a few categories (e.g., Sales by Quarter), you can afford to use wider bars with very little padding. For a chart with many categories (e.g., Sales by Product), you'll need to leave more padding to keep the visual from becoming a dense, unreadable block.
• Stay Consistent: If you have multiple bar charts on the same report page, try to use a similar Inner Padding setting for each. This creates a cohesive and professional look across your dashboard.

A Creative Trick: Change the Axis Type from 'Continuous' to 'Categorical'

Sometimes, the "thin bar" problem isn't about padding at all. It's about how Power BI is interpreting your data, especially when you use a date or a number on your main axis (the X-axis for a column chart or Y-axis for a bar chart).

By default, if Power BI sees numbers or dates, it often assumes the axis should be Continuous. This means it treats the axis like a number line, allocating space for all possible values, even those for which you have no data. The result? Your actual bars only take up tiny slivers of the chart, appearing extremely thin.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

When and How to Switch to a 'Categorical' Axis

The solution is to tell Power BI to change to a Categorical type. This forces the chart to treat each value on the axis as an individual, distinct label instead of a point on a continuous scale. It will only create space for the data points you actually have, and the bars will automatically resize to fill the chart area.

Here’s how to make the switch:

1. Select your chart visual.
2. Go to the Format visual pane (the paintbrush icon).
3. Expand the X-axis section (or Y-axis if you're using a horizontal bar chart).
4. Look for the Type option. It will likely be set to "Continuous."
5. Click the dropdown menu and change it to "Categorical."

You should see an immediate, dramatic change. The bars will become properly proportioned, using all the available space. This technique is especially useful in these scenarios:

• Year-over-Year Data: If you have a column chart showing revenue for the years 2020, 2021, and 2022, a continuous axis might leave large gaps. A categorical axis will treat them as three distinct labels.
• Survey Scales: When visualizing survey data (e.g., responses on a scale from 1 to 5), treating the numbers as categories is almost always the right choice.
• Non-Sequential Numerical IDs: If your categories are numbers but not sequential (e.g., product models 101, 250, and 515), a categorical axis will prevent empty space for all the numbers in between.

Controlling Bar Width in Small Multiples

The Small Multiples feature lets you break down a single chart into a grid of mini-charts. For example, you might show a bar chart of sales by product, repeated for different countries. But how do you control bar spacing in this grid?

When you're using Small Multiples, you have two levels of spacing to manage:

1. Padding for the Grid: This is the space between the mini-charts. You can find these controls in the Format visual pane under the Small multiples section. Inside the Layout settings, you can adjust grid padding to make the entire layout more compact or spaced out.
2. Padding for the Bars: The Inner Padding setting we covered first still works here! It continues to control the space between the bars within each individual mini-chart.

To get a great look, you may need to adjust both. First, tweak the global grid padding in the Small multiples menu, and then fine-tune the bar width within each chart using the Inner Padding slider in the Columns/Bars menu.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Beyond Bar Size: Other Tips for Readable Bar Charts

Adjusting bar width is a great step, but it is just one piece of creating an effective chart. Here are a few other quick tips to make your bar charts even better:

• Use Data Labels: Turn on data labels to display the exact value of each bar. This saves your audience from having to trace lines back to the axis to figure out a number. It makes your chart cleaner and easier to understand.
• Sort Logically: Always sort your bars in a way that makes sense. Descending or ascending order is usually best, as it makes it easy to spot top and bottom performers. Alphabetic sorting can also work if the category names are important.
• Limit Your Categories: If you have more than 10-12 categories, a bar chart can become cluttered and unreadable. Consider filtering your data to show only the "Top 10," or group smaller categories into a combined "Other" bucket.
• Use Color Meaningfully: Don't just add color for decoration. Use it to highlight a specific finding - for example, making one bar a contrasting color to draw attention to it, or using shades of the same color to show intensity.

Final Thoughts

Mastering bar size in Power BI is a matter of knowing where to look. By adjusting the "Inner Padding" setting in the Format pane or by changing your axis "Type" from Continuous to Categorical, you can quickly transform thin, hard-to-read bars into a clear, compelling, and professional-looking visualization.

While mastering specific formatting details within business intelligence tools is a handy skill, the ultimate goal is to get answers quickly, without getting stuck in settings menus. We designed Graphed for exactly that. Instead of clicking through panes and sliders, you can simply ask, "Show me a bar chart of sessions by traffic source for the last 90 days." Our AI instantly connects to your data (like Google Analytics) and produces a perfectly formatted, easy-to-read chart so you can focus on the insights, not the configuration.