Week as Category on Bar chart

[Aditya Singh 3]

Hi, I am trying to get the week values on the bar chart category axis. I tried week fucntion but it gives the week number instead of week as expected. Is there any way to achieve the below way to show week.

[Khushboo Rabadia]

You can create week date calculated column referencing the formula/expression providedhere:

https://weeknumber.net/how-to/excel

DateAdd("dd",Integer(-6 + (7 * [Wknum]) - DayOfWeek(DATE([Year],1,4)) + 1),Date([Year],1,1))This formula is assuming you need to show week start from Saturday and you have year and week number values in dataset.

If you want week start from Sunday, in above formula, use -5 instead of -6.

If week should start from Monday, in above formula, use -4 instead of -6

 

If you have dates column in dataset and trying to find week start date for that particular date, you can reference below KB article:

https://support.tibco.com/s/article/How-to-show-the-first-day-of-each-week-on-the-x-axis-of-a-chart