How to Change Axis Range in Power BI

Setting the right axis range on your Power BI charts can be the difference between a clear, compelling story and a confusing one. While Power BI's automatic settings are helpful, taking manual control allows you to highlight specific data ranges, standardize comparisons, and make your reports much more insightful. This tutorial will walk you through a couple of ways to adjust your axis range, from a simple static method to a more powerful, dynamic approach using DAX.

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

Why Should You Change the Axis Range in Power BI?

Power BI does a pretty good job of setting the axis range on its own, but its "best guess" isn't always what you need. Manually setting the start and end points of your axis gives you a few key advantages:

• Improved Readability: If your data values fluctuate within a tight range far from zero - say, stock prices between $150 and $160 - an axis starting at zero can flatten your line chart, hiding meaningful variations. Zooming in on the relevant range makes these trends immediately obvious.
• Consistent Comparisons: Imagine you have two charts showing sales for different products. Product A sold between $10,000 and $12,000, while Product B sold between $3,000 and $5,000. Power BI will create two different Y-axis scales, making a visual comparison difficult. By setting both charts to the same range (e.g., $0 to $15,000), you create an apples-to-apples view that tells the real story at a glance.
• Contextual Storytelling: Sometimes you need to show performance against a specific goal. If your sales target is $100,000, setting your axis maximum to $100,000 or slightly above provides immediate visual context as to how close you are to hitting your target, which an automatic axis might obscure.

Setting a Static Axis Range (The Easy Method)

The simplest way to control your axis is by setting hard-coded minimum and maximum values. This is perfect when you have an established range you always want to show, like a percentage scale from 0 to 100 or when standardizing visuals across a report page.

Let's use a standard bar chart showing monthly sales as an example.

Step-by-Step Guide:

1. Select Your Visual: Click on the chart you want to modify in your Power BI canvas. This will activate the "Visualizations" pane on the right side of your screen.
2. Open the Formatting Pane: In the "Visualizations" pane, click on the icon that looks like a paintbrush. This is the "Format your visual" tab.
3. Find the Axis Settings: Look for the "Y-axis" section (or "X-axis" if you're adjusting a horizontal axis). If the section is collapsed, click on it to expand the options.
4. Set Your Minimum and Maximum: Inside the Y-axis settings, you'll see a sub-section called "Range." Here, you'll find input boxes for "Minimum" and "Maximum." As a default, they will likely be set to "Auto."
5. Input Your New Values: Type your desired start and end values into the boxes. For instance, if your sales are hovering around $50,000 but your business never dips below $40,000, you could set the "Minimum" to 40000 and the "Maximum" to 75000 to zoom in on the monthly variations.

That's it! Your chart's axis is now fixed to the range you specified. It's simple and effective for many common reporting scenarios.

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

Creating a Dynamic Axis Range with DAX

Setting a static range works well... until it doesn't. What happens when a user filters the report? If your static maximum is $100,000, but a filter shows a product with only $5,000 in sales, your visual will be a tiny bar at the bottom with a lot of empty space. This is where a dynamic axis becomes incredibly powerful.

Our goal is to create an axis that smartly adjusts its range based on the data currently being displayed in the visual after any slicers or filters have been applied. We'll accomplish this with a clever combination of DAX measures and a lesser-known feature in the Analytics pane.

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

Step 1: Create Your Core DAX Measures for Min and Max

First, we need to create two DAX measures that calculate the minimum and maximum values for the data we want to display. These measures will respond to any filters applied to the report page.

Let’s assume you have a 'Sales' table with a 'Total Revenue' column.

Go to the "Modeling" tab and click "New Measure." Enter the following formulas:

For the Maximum Value: We’ll find the maximum revenue and add a 10% buffer to ensure the data point doesn’t sit awkwardly at the very top of the chart.

Dynamic Max =
MAXX(
    ALLSELECTED('Sales'),
    'Sales'[Total Revenue]
) * 1.1

For the Minimum Value: Similarly, we’ll find the minimum revenue and subtract 10% to create a buffer at the bottom. The IF statement prevents negative values if your data is close to zero.

Dynamic Min =
MINX(
    ALLSELECTED('Sales'),
    'Sales'[Total Revenue]
) * 0.9

Let's break down that DAX very quickly. MAXX and MINX are iterators that find the largest and smallest values in your table. The key ingredient is ALLSELECTED('Sales'). This function tells Power BI to look at the maximum value within the context of whatever filters are currently selected on the page, whether by a slicer or another visual.

Step 2: The Easiest Way to Apply Dynamic Measures to Your Axis Using a Little-Known Feature in the "Analytics Pane"

Now, here's the part where you might expect to drop these new measures into the "Range" settings we used before. Unfortunately, Power BI doesn't allow that directly. But we can achieve the same result with a clever workaround using error bars.

1. Select Your Visual: Click on your chart to select it.
2. Open the "Analytics" Pane: In the "Visualizations" pane, click the magnifying glass icon. This takes you to the Analytics pane, where you can add things like trend lines and forecasts.
3. Add “Error Bars”: Scroll down until you find the "Error bars" option. Expand it for the 'Total Revenue' series. Here you can enable and disable this option.
4. Assign Your Measures: Once enabled, you'll see fields for "Upper bound" and "Lower bound." This is where the magic happens.
5. Make the Error Bars Invisible: You'll see strange-looking error bars appear on your chart. We don't actually want to see them, we just want their effect on the axis. To hide them, go back to the "Format your visual" (paintbrush) pane. Find the "Error bars" formatting section, expand it, and

And you are done!

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

Putting It All Together: An Example

Imagine your report has a bar chart showing sales by month and a slicer filtering by "Country." When "USA" is selected, the highest monthly sale is $950,000. Your visual's Y-axis will automatically adjust to about $1.05M (the Dynamic Max of $950k * 1.1). When the user clicks "Canada," where the highest monthly sale is only $200,000, the axis instantly resizes to have a maximum of around $220,000.

The visual remains clean, readable, and perfectly scaled to the data being shown, regardless of how the user filters it. You've created a genuinely interactive and user-friendly experience that static axes simply can't match.

Final Thoughts

Controlling the axis range in Power BI is a fundamental skill that elevates your reports from basic charts to professional, insightful dashboards. Whether you use the simple static method for standardization or the more advanced DAX-driven dynamic approach for interactivity, you're taking control of how your data story is told.

We find that mastering little details like this is where analysts spend most of their time - tweaking visuals, writing DAX, and manually shaping reports. With tools like Graphed , we aim to eliminate that friction. By connecting your data sources and simply describing the dashboard you need in plain English - like "Show me a line chart of monthly revenue with a dynamic axis" - you can skip the complex steps and get straight to the insights, allowing your team to explore data without getting stuck on technical hurdles like DAX or formatting panes.