Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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.
@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.
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!
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
60 | |
58 | |
54 | |
36 | |
33 |
User | Count |
---|---|
79 | |
66 | |
45 | |
44 | |
42 |