Bar chart for dynamic YTD and PYTD periods

[JoeChar]

I am trying to create a dynamic bar chart to show YTD vs PYTD. 

The issue I am running into is applying the same date range filter on the PYTD period, which is returning as the full year value.

[JoeChar]

I have weekly data, and I am trying to make a FYTD24vFY23 bar visual (FY begins 7/1).

W.e. Date        FY23                 FY24

7/2/2022	$13,121,838
7/9/2022	$12,759,192
7/16/2022	$13,398,575
7/23/2022	$17,037,888
7/30/2022	$30,204,797
8/6/2022	$12,546,212
8/13/2022	$12,076,206
8/20/2022	$12,142,771
8/27/2022	$11,650,503
9/3/2022	$12,031,827
9/10/2022	$11,952,046
9/17/2022	$13,070,277
9/24/2022	$12,953,763
10/1/2022	$12,791,149
10/8/2022	$13,651,551
10/15/2022	$13,935,884
10/22/2022	$13,542,171
10/29/2022	$18,039,172
11/5/2022	$34,197,430
11/12/2022	$23,116,411
11/19/2022	$13,074,474
11/26/2022	$12,668,420
12/3/2022	$13,075,398
12/10/2022	$12,812,230
12/17/2022	$13,117,308
12/24/2022	$13,571,376
12/31/2022	$16,350,135
1/7/2023	$18,443,560
1/14/2023	$23,157,713
1/21/2023	$13,690,966
1/28/2023	$14,438,002
2/4/2023	$16,211,010
2/11/2023	$13,995,096
2/18/2023	$12,968,470
2/25/2023	$14,235,256
3/4/2023	$15,518,528
3/11/2023	$14,692,539
3/18/2023	$13,990,993
3/25/2023	$13,794,816
4/1/2023	$13,821,946
4/8/2023	$14,225,342
4/15/2023	$14,644,725
4/22/2023	$13,481,286
4/29/2023	$13,095,421
5/6/2023	$13,778,409
5/13/2023	$13,423,280
5/20/2023	$13,504,579
5/27/2023	$13,358,066
6/3/2023	$13,425,817
6/10/2023	$13,564,364
6/17/2023	$13,288,476
6/24/2023	$13,246,378
7/1/2023		$14,512,892
7/8/2023		$16,087,952
7/15/2023		$19,926,589
7/22/2023		$22,394,453
7/29/2023		$16,505,000
8/5/2023		$21,401,310
8/12/2023		$18,135,006
8/19/2023		$12,793,505
8/26/2023		$12,757,819
9/2/2023		$13,106,240
9/9/2023		$13,270,826
9/16/2023		$13,492,657
9/23/2023		$14,246,501
9/30/2023		$16,636,371
10/7/2023		$22,020,264
10/14/2023		$19,942,445
10/21/2023		$12,298,244
10/28/2023		$12,939,894
11/4/2023		$13,236,870
11/11/2023		$13,685,367
11/18/2023		$13,115,116
11/25/2023		$12,566,136
12/2/2023		$14,165,297
12/9/2023		$14,136,075
12/16/2023		$14,172,033
12/23/2023		$14,728,362
12/30/2023		$16,385,393
1/6/2024		$14,411,567
1/13/2024		$12,836,270
1/20/2024		$12,751,161
1/27/2024		$12,442,504
2/3/2024		$13,802,142

Using sum(Sales[sales]) yields a visual that includes 52 weeks for FY23 and 32 weeks for FY24:

I would like to have both periods be the same increment of time. In this example I have weekly data, but in most cases my data is daily, so the most recent actualized period is desired. Also would be intesting to be able to calculate for more than just PY, but every year prior (e.g. FY22, FY21, etc.).

[Daniel29195]

@JoeChar 

can you share a representation of the problem you are facing ? 

and how you would like the output to be ? 

that would be helpful.

best regards