Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
So i have had a project where they want to see sales report based on the last 8 weeks and the week to start on Monday. Managed this no issue, however i can't remove the format 00:00:00 from x axis label without it then saying previous day (Sunday), instead of Monday. Any help would be greatly appreciatted.
Solved! Go to Solution.
Hi @tristanweeks47 ,
Please update the formula of calculated column [WeekStartDate] and update the date type as "Date":
WeekStartDate =
DATEADD (
opportunity[Created On].[Date],
-1 * WEEKDAY ( opportunity[Created On].[Date], 2 ),
DAY
)
Best Regards
Hi @tristanweeks47 ,
Please update the formula of calculated column [WeekStartDate] and update the date type as "Date":
WeekStartDate =
DATEADD (
opportunity[Created On].[Date],
-1 * WEEKDAY ( opportunity[Created On].[Date], 2 ),
DAY
)
Best Regards
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
106 | |
104 | |
89 | |
66 |
User | Count |
---|---|
162 | |
133 | |
132 | |
92 | |
88 |