PowerBI.tips

Center the X-Axis on a Line Chart

July 9, 2018 By Seth Bauer
Building Reports
Center the X-Axis on a Line Chart

Sometimes when your working on a line chart you want the x-axis to stay centered on a chart. This tutorial will walk you through how to create an X-Axis that will always center it’s self on the graph.

Video Support Material:

The measures discussed within this tutorial are:

Variance All = SUM(Sales[Variance])

The column name Variance is found in the data table called sales.  This is just a numerical column.

After summing up all the variances we can calculate the min and max lines.

Const Max Line = [Variance All] * 1.2

Const Min Line = -1 * [Const Max Line]

Finally to calculate the variance to date you can use this filtered measure, which will only produce historical values.

Variance To Date = CALCULATE([Variance All], FILTER(‘Sales’,‘Sales’[Date] <= EOMONTH(TODAY(),0)))

Thanks for watching our short tutorial.  If you like this video please be sure to follow me (Seth Bauer) on Twitter, LinkedIn and be sure to subscribe to the PowerBI.Tips YouTube channel.

#power-bi

Previous

Power BI and Sudoku – Yes Please

Next

Tic Tac Power BI

More Posts

Mar 25, 2026

Git Best Practices Diff Noise & Naming - Ep. 513

Mike and Tommy break down the Git habits that make pull requests easier to review, cleaner to merge, and less painful to maintain over time. If your team fights diff noise, inconsistent naming, and mystery changes buried in commits, this episode gives you a practical framework for cleaning that up.

Mar 20, 2026

Publish to Web vs. Embedded - Ep. 512

Mike and Tommy break down the real difference between Publish to Web and Power BI Embedded, and why mixing them up creates security and governance headaches fast. If you need to share reports outside your organization, this episode gives you the practical framework for choosing the right option without accidentally turning convenience into a data leak.

Mar 18, 2026

Scaling a Power BI Side Hustle - Ep. 511

Mike and Tommy break down what it actually takes to grow a Power BI side hustle from occasional freelance work into a repeatable consulting engine. If you're balancing client delivery, productized offers, and the reality of limited time, this episode gives you a sharper playbook for scaling without creating chaos.