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 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?

  • FVal's avatar
    FVal
    Helper I
    6 years ago

    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