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 the bin name changed to week name. Is there another way of dividind a date field into weeks of the year and use it in the Axis part? Also, is this a generic thing, to have the week missing but still have the Day, Month, Year or is it something that can be enabled in the settings? Thank you,V.

FVal add column with following expression: x = "Week " & FORMAT( WEEKNUM( 'Calendar'[Date] ), "0#" ) Would appreciate Kudos 🙂 if my solution helped.

Axis - use date per Week | Microsoft Fabric Community

Super User

FVal you can add another column in the calendar table. Do you want start of the week or end of the week date? When the week starts? Sunday/Monday?

Helper I

Hi Parry,

Thank you for your quick reply. I would need to have it same as the calendar week number, as example below:

etc.

Best Regards,