Chart Display Week Begin Date Instead of Week Number

[sqlpuzzle]

Hi,

I have a sample attached.

The issue that I am having is with displaying X-axis Labels, In the Weekly view of the cyclical chart. I would like to see labels like 02 Nov 2020, 09 Nov 2020, 16 Nov 2020 instead of numbers like 44, 45,46 ( week).  I want the date of the Monday of the week displayed in the label.

How can this be achieved.

[Kushal_Chawda · Accepted solution]

@sqlpuzzle  create week like below

Weekstart(date,0,0) as week

[sqlpuzzle]

Thanks that helped.

Date(floor(WeekStart(date,0,0)),'DD MMM YYYY')as week

[Kushal_Chawda]

@sqlpuzzle  yes, if you need different format then you can format it using Date function