Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
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.
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.
@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
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |