Forum Discussion

FVal's avatar
FVal
Icon for Helper I rankHelper 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
Icon for Super User rankSuper 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
Icon for Helper I rankHelper 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
    Icon for Helper I rankHelper 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
      Icon for Super User rankSuper 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
        Icon for Helper I rankHelper I
        6 years ago

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