Forum Discussion
Displaying data as week commencing in a chart
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
Not entirely sure what you want. I have Week Starting: https://community.powerbi.com/t5/Quick-Measures-Gallery/Week-Starting/m-p/391487#M123
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Sorry but i dont understand your response.
I have the W/C data in a table with the rest of my data. I can display the data by week number but not by w/c.
WC Date Week Calls In Calls Ans Calls Ans (%) ❤️ mins
| 04-Nov-19 | 23 | 3129 | 2114 | 35.9% |
| 11-Nov-19 | 24 | 2785 | 2206 | 36.3% |
| 18-Nov-19 | 25 | 2522 | 2124 | 44.1% |
| 25-Nov-19 | 26 | 2727 | 2390 | 46.8% |
| 02-Dec-19 | 27 | 3620 | 2754 | 33.0% |
| 09-Dec-19 | 28 | 4237 | 2796 | 22.1% |
| 16-Dec-19 | 29 | 3682 | 2513 | 30.1% |
| 23-Dec-19 | 30 | 1294 | 917 | 22.2% |