Power BI - Moving X-Axis (Easy)

In this Power BI tutorial, I will show you how to create a line chart with an X-axis that moves dynamically! You will be able to set a range of days and your chart will iterate through each day of data!
Elite Power BI Consulting:
bielite.com
To enroll in my introductory or advanced Power BI courses:
training.bielite.com/
Connect with me on Twitter!
/ powerbielite

[@jaredfiacco1107]

Really informative and super easy! Thanks for the video!

[@AnandKrishnanPuravangara]

Thank you!

[@Coppermind343]

Thanks a lot for this video. I can see so many possible application for this!

[@BIElite]

I agree! Thanks for watching, Patrick

[@cristian.angyal]

Great video Parker. Thanks for sharing it!

[@BIElite]

Thanks Cristian!!

[@terpstry]

Great video, very creative! Thanks for sharing.

[@BIElite]

No problem, Ytzen!

[@kkskhin7208]

Thank you so much for sharing. It is really impressive

[@BIElite]

No problem!

[@hectoralvarorojas1918]

Great video!
As usual!
By the way, congratulations for your introductory or advanced Power BI courses.
Regards!

[@BIElite]

Thanks Hector! I appreciate the support. I’m hoping they can be of use to both beginner and advanced Power BI users.

[@hectoralvarorojas1918]

​@@BIElite Hi, Parker: I am sure it will. If you keep exposing there the topics as you regurarly do in your short videos then the goodness can be guaranteed.
Best!

[@tubeitz]

Thanks for sharing 👍👍

[@BIElite]

No problem, Varun!

[@ncbshiva]

Superb

[@BIElite]

Indeed, shiva!

[@raz8657]

Nice!

[@BIElite]

Yes indeed!

[@praveenkakumanu919]

good video

[@BIElite]

Thanks Praveen!

[@sunvalleysyntropic]

Very cool! How would you do this if you have multiple lines in the line chart? Would you create a measure for every line, same as the Sum within range?

[@sunvalleysyntropic]

I think from watching it again I have to filter the 'sum within range' to is not blank.

[@BlackBeardPRO]

Does the play axis accept time format (hours, minutes, seconds)? I'm trying to do that but it doesn't work

[@SergiyVakshul]

It looks unusual, draws a viewer attention. But the more I look at the result the more curious I get - what drove you to create that kind of display? Why just not use a trivial Line Chart with X axis type set to Categorical which makes using horizontal scroll bar possible?

[@nicoweyers8162]

This is so enormously helpful. But also enormously annoying, when you are unable to actually create a new table, as you are working in a pre-made data model.
Any way around that?

[@k-lone]

how to keep the chart from auto-resizing the y-axis when the data changes? It's hard to follow a trend when it gets blown up to the size of the window when just the previous year the "v" was only at the top... know what I'm saying?

[@mcmunteanu]

I am working with a database that has monthly data. Using your template, PowerBI is looking for daily data.
How can I make DayRange to iterate through each month? Thank you.

[@BIElite]

A quick answer would be to simply multiply the Day Range by 30. You can also use the DATEADD function for a more sophisticated approach.