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.

     

     

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.

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        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.