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

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