Weekly Data Format

[tristanweeks47]

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. 

[Anonymous · Accepted 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