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

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.

    • FVal's avatar
      FVal
      Helper I
      6 years ago

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

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

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