Display data with different time duration together

[dqian]

I have to show weekly data in two years together, in which the data in previous year has 52 weeks, and the data in current year has YTD. I would like to know how to show them together like the picture below (green for prevous year, orange for current year). Thank you.

 

[dqian · Accepted solution]

Okay, Thank you.

[v-yuezhe-msft]

@dqian,

Could you please share dummy data of your table? For the previous year, do you still want to calculate YTD?


Regards,
Lydia

[dqian]

Hi Lydia, thank you for your response. Below is my dummy data. I want to show the both 2017 and 2018 year's percentage together.

YEAR	WEEK	%
2017	2	81%
2017	3	91%
2017	4	54%
2017	5	48%
2017	6	67%
2017	9	81%
2017	11	25%
2017	13	61%
2017	15	80%
2017	16	45%
2017	17	77%
2017	18	72%
2017	19	52%
2017	21	100%
2017	22	48%
2017	23	75%
2017	24	20%
2017	25	49%
2017	26	77%
2017	27	73%
2017	28	29%
2017	29	58%
2017	30	78%
2017	31	56%
2017	32	48%
2017	33	71%
2017	34	83%
2017	35	94%
2017	36	57%
2017	37	60%
2017	38	61%
2017	39	90%
2017	40	58%
2017	41	72%
2017	42	69%
2017	43	61%
2017	44	55%
2017	45	47%
2017	46	54%
2017	47	51%
2017	48	48%
2017	49	48%
2017	50	72%
2017	51	54%
2017	52	37%
2018	1	44%
2018	2	61%
2018	3	52%
2018	4	61%
2018	5	42%
2018	6	51%
2018	7	33%
2018	8	10%
2018	10	50%
2018	11	41%
2018	12	45%
2018	13	84%

[ask4atish]

Hi @dqian,

Just tried with your data. I believe this is what you are looking for.

[dqian]

Yes. But what I got is. It won't display all the weeks for 2017.

[ask4atish]

Change type as continuous to categorical under x axis properties.

[dqian · Accepted solution]

Okay, Thank you.

[ask4atish · Accepted solution]

Hi @dqian,

Please mark my response as solution, if it really healped you. 

Regards,

Atish