Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/
Proud to be a 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
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://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA
https://www.linkedin.com/company/77757292/
Proud to be a Super User!
How did you create the Start of Week column in your Date table?
Can't believe how simple that was. Thank you 😊
User | Count |
---|---|
79 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
100 | |
91 | |
83 | |
61 |