Axis - use date per Week

[FVal]

Hi experts,

We have to present in some reportds data structured by week number or similar.

I tried to use bins, set 7 days and use it as such, but it looks a bit awkward and also I can't get the bin name changed to week name.

Is there another way of dividind a date field into weeks of the year and use it in the Axis part?

Also, is this a generic thing, to have the week missing but still have the Day, Month, Year or is it something that can be enabled in the settings?

Thank you,

V.

[parry2k]

@FVal you can add another column in the calendar table. Do you want start of the week or end of the week date? When the week starts? Sunday/Monday?

[FVal]

Hi Parry,

Thank you for your quick reply. I would need to have it same as the calendar week number, as example below:

Week 01	December 30, 2019	January 5, 2020
Week 02	January 6, 2020	January 12, 2020
Week 03	January 13, 2020	January 19, 2020
Week 04	January 20, 2020	January 26, 2020
Week 05	January 27, 2020	February 2, 2020
Week 06	February 3, 2020	February 9, 2020
Week 07	February 10, 2020	February 16, 2020
Week 08	February 17, 2020	February 23, 2020
Week 09	February 24, 2020	March 1, 2020
Week 10	March 2, 2020	March 8, 2020
Week 11	March 9, 2020	March 15, 2020
Week 12	March 16, 2020	March 22, 2020
Week 13	March 23, 2020	March 29, 2020
Week 14	March 30, 2020	April 5, 2020
Week 15	April 6, 2020	April 12, 2020

etc.

Best Regards,

V. 

[parry2k · Accepted solution]

@FVal add column with following expression:

x = "Week " & FORMAT( WEEKNUM( 'Calendar'[Date] ), "0#" )

Would appreciate Kudos 🙂 if my solution helped.

[FVal]

Great, will use it as described. Instead of Calendar [Date] I could use it for any date fields I need, correct?

Best Regards,

V.

[FVal]

Hi,

So, used, it does the magic, so thank you, still, a little bit of help is required, as, for some reason, the order is strange:

W5, W3, W4, W7, W8, W10, W11,W2...

How can it be made to show the correct order?

Best Regards,

V.

[parry2k]

@FVal you should be getting W01, W02 W03....

and make sure your visual is sorted correct, click on top right corner (3 dots) and check the sort order, that it is sorted by week column

Would appreciate Kudos 🙂 if my solution helped.

[FVal]

Yey, that solved the order, only Week 1 is still missing (it was not displayed at all).

[parry2k]

@FVal do you have data for week 1, not sure why it will be missing?

[FVal]

sorted now, it was due to another filter, showing data after 01.01.2020, while week 1 has few days in 2019.

Appreciate your support,

Have a nice day