Forum Discussion

FVal's avatar
FVal
Helper I
6 years ago
Solved

Axis - use date per Week

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 ...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    FVal add column with following expression:

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

     

    Would appreciate Kudos 🙂 if my solution helped.

     

     

parry2k's avatar
parry2k
Super User
6 years ago

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's avatar
FVal
Helper I
6 years ago

Hi Parry,

 

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

 

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

etc.

 

Best Regards,

V. 

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    FVal add column with following expression:

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

     

    Would appreciate Kudos 🙂 if my solution helped.

     

     

    • FVal's avatar
      FVal
      Helper I
      6 years ago

      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's avatar
        FVal
        Helper I
        6 years ago

        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.