Forum Discussion
Helper IVWeekly Data with Monthly X-Axis with a Line and Clustered Column Chart
Hi All,
PBIX file.
Below is an image of what I’m trying to replicate. Essentially, I want the granularity of the bars to be weekly but the x-axis to only show Monthly. As an example, I have highlighted the month of October in Power BI which is showing five different dates for each week. In excel you can show weekly bars but monthly dates on the x-axis. Is this possible?
Thank you.
Hi, CaveOfWonders
Is that what you want?
https://www.dropbox.com/s/rzhdf7oidb46w1w/Sample%28allure-analytics.com%29.pbix?dl=0
Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.
Appreciate your Kudos !!!
4 Replies
- ALLUREAN
Solution Sage
Hi, CaveOfWonders
Is that what you want?
https://www.dropbox.com/s/rzhdf7oidb46w1w/Sample%28allure-analytics.com%29.pbix?dl=0
Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.
Appreciate your Kudos !!!
- CaveOfWonders
Can't believe how simple that was. Thank you 😊
RivAdvocate I
How did you create the Start of Week column in your Date table?
- TomMartens
Super User
Hey CaveOfWonders ,
in addition to the solution ALLUREAN provided you may find this article useful:
Improving timeline charts in Power BI with DAX - SQLBI
Basically, if the x-axis is considering the labels as categorical, it's not possible to use a different granularity for the data points and the axis labels. For this reason, it becomes necessary to use continuous values:
Hopefully, this adds additional insights.
Regards,
Tom
