Weekly Data with Monthly X-Axis with a Line and Clustered Column Chart

[CaveOfWonders]

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.

[TomMartens]

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

[ALLUREAN · Accepted solution]

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 !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/

[Riv]

How did you create the Start of Week column in your Date table?

[CaveOfWonders]

Can't believe how simple that was. Thank you 😊