Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
brkling
New Member

How to show graph interval by week

I have a spreadsheet with data that has multiple items by day. When showing one of the graphs, I want it to display the time interval on the x axis by week - how do I achieve this? Seems pretty simple but I can't figure out how to make it happen.

5 REPLIES 5
Greg_Deckler
Super User
Super User

@brkling - This is going to depend on your data. If you have a date, you could create a calculated column using WEEKNUM:

 

https://support.office.com/en-US/article/WEEKNUM-Function-DAX-e636ef36-180a-4e2d-a29b-8f549c258da0

 

And use that as your x-axis.

 

If this doesn't solve your problem, please post an example data row or partial data row.

 

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

A date dimension is always the appropriate solution to this sort of problem.

Hi guys,

 

I have a similar problem, that I need to show public in a park per week but my problem is that I need a line per year.

My X should be the week numbers but need two Y, one for showing public per week of 2016 and another for 2017.

 

How would I do that?

Hi @ricardinhorio.

 

You can do this by creating two calculated measures that filter the public per year (one for 2016 and other for 2017). Something like:

 

Public2017 = FITLER(Table[ColumnW/PublicNumbers]; YEAR(Table[ColumnW/DateOfTheColectedData]) = 2017)

Public2016 = FITLER(Table[ColumnW/PublicNumbers]; YEAR(Table[ColumnW/DateOfTheColectedData]) = 2016)

 

And using this calculated measures as line values in your chart.

 

Hope it helps!

Anonymous
Not applicable

 Hi brkling,

 

   look at this post made by @elliotdixon

 

http://community.powerbi.com/t5/Desktop/Display-this-week-amp-this-month-data/m-p/11207#M2459

 

..meanwhile I look for a custom solution for your problem.

 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.