Getting Weeks in dates instead of week numbers

[Anonymous]

I have a report where we need to measure weekly.  However, I can only get BI to do week numbers not dates of that assigned week.

Example: Week 10 instead of 03/10/20 and so on.

[v-xicai · Accepted solution]

Hi @Anonymous ,

You may create a calendar table,  and create WeekNum column in it, then create relationship with your fact data table.

Table: Calendar=CALENDARAUTO()

Column: WeekNum = "Week"& WEEKNUM(Calendar[Date])

Then you may put the columns Calendar[WeekNum] and Calendar[Date] into X axis box of chart visual one by one.  If you need to see Week Number contains which related dates, then click drill up and drill down options.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jusTodd]

A little new to this, so I am a little curious, why would one not simply create a New Group on the date, with a Bin Size of 7 days?

I tried this out and it seemed to work out ok, giving me a summary of data for the week range. 

[Anonymous]

This is awesome but I'm struggling with geting it to work with the visual I'm using.

Can you share a screenshot of how you are designating the axis's with your DAX ?

[TomMartens]

Hey @Anonymous ,

this is simply because is a range, for it's not possible to have an axis label that looks like this: From weekstart - to weekend.

Nevertheless, you can consider creating a new column inside your table that determines the start day of the week or the end date of the week.

This thread provides a simple solution for this, then you can use this column as the axis label:
https://community.powerbi.com/t5/Desktop/Week-commencing-in-DAX/m-p/241304#M107084

Regards,

Tom