Forum Discussion

Spireite4's avatar
Spireite4
Regular Visitor
6 years ago
Solved

Displaying data as week commencing in a chart

I want to show the week comencing on the x-axis (e.g. 2nd Mar, 9th Mar etc) but i only get day, month, quarter or year. I know i can display it by week number but i want to see the actual weekly dat...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    Please try to create a calculated table first:

    Date = CALENDAR(MIN('Table'[WC Date]),MAX('Table'[WC Date]))

    Then create one-to-one relationship between them.

    Create a column to show all date's week NO. in this new date table:

    WeekNo = ROUNDDOWN(DATEDIFF(MIN('Date'[Date]),'Date'[Date],DAY)/7,0)+MIN('Table'[Week])

    Then create a new column to format the date and weekNo:

    Month-WeekNo = FORMAT('Date'[Date],"MMM")&"-"&'Date'[WeekNo]

    Choose a line chart to show the result:

    Hope this can help.

     

    Best Regards,

    Giotto Zhi

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

Please try to create a calculated table first:

Date = CALENDAR(MIN('Table'[WC Date]),MAX('Table'[WC Date]))

Then create one-to-one relationship between them.

Create a column to show all date's week NO. in this new date table:

WeekNo = ROUNDDOWN(DATEDIFF(MIN('Date'[Date]),'Date'[Date],DAY)/7,0)+MIN('Table'[Week])

Then create a new column to format the date and weekNo:

Month-WeekNo = FORMAT('Date'[Date],"MMM")&"-"&'Date'[WeekNo]

Choose a line chart to show the result:

Hope this can help.

 

Best Regards,

Giotto Zhi