X- axis date Display on weekly aggregation

[rajendraongole1]

Hi 

Want to display the data in the form of below attached chart format on X axis.

for each month we have four or 5 weeks approximately

eg., in 5th month we have 5 weeks and day should comes as adding with 7 (+7 days) aggregatin it .

for 6th month too in 6th month we have 4 weeks  so for each week the data should aggregate and comes as 6/7,6/14/6/21 and last week 6/28  adding next 7 days data.

any suggestion to implement this logic. kindly suggest.

Regards,

Rajendra

[v-yangliu-msft · Accepted solution]

Hi  @rajendraongole1 ,

I created some data:

2020.3.1 – 2020.4.30

Here are the steps you can follow：

1. Create calculated column.

date_co =
var _weekday=WEEKDAY([date],2)-1
return
[date]-_weekday

2. Place [date_co] above Axis, and in Format, select X axis – Type – Categorical

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rajendraongole1]

Thanks @amitchandak .

example: For current month June 2021 axis fields should expected as below:

6/7 , adding next 7 days as to the date as 6/14,6/21,6/28, for 7th month 7/5 date has to pick. 

[amitchandak]

@rajendraongole1 , do you need 4,4,5 calendar or something else

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

for 4 4 5 -https://www.youtube.com/watch?v=JqVnqMLGWDY