SameperoidLastYear Drillthrough

[Anonymous]

Hi, I am trying to create StackedLine chart, where Bars represent rolling twelve months (June 2020 to May 2021) and I created another calculation to display SameperiodLastYear (June 2019 to May 2020) and placed in lines. I created a details page to enable drillthrough from graph to details. Drillthrough is working on bars however when I select line and click on drillthrough it still populating values related to the bar in details page. I think even if I click on line drillthrough forcing values related to bar. If I place both Bars(rolling twelve months) and sameperiodlastyear in different charts then drillthrough working fine.  Please help is there any workaround to make it work both drillthrough (Bar &Line) in Stackedline chart.

Thanks

[v-jayw-msft]

Hi @Anonymous ,

Not very clear, better to share some sample data with screenshot and the expected result to us.

Best Regards,

Jay

[Anonymous]

Hi Below the sample data. Whit this data I was able to calculate count of Order IDs by current rolling 12 months and SamePeriodLastYear (using SamePeriodLasyYear Dax). I used Combo chart to populate both segments (Bar being rolling 12 months and line being SamePeriodLasyYear). Client wanted to look at the detailed records where in if we click on current months bar then he must see the current month Order IDs. I created drilll through for all detailed order ids. 

Drill through always passing month (respect to Bar) to detailed page I am good there, however when I click on the Line it still Passing month assiciated to Bar not the line. 

For example if I clicek on June 2021 bar drill through showing detailed records with respect to June 2021 and If try to drillthrough on respective SamePeriodLastYear line drillthrough supposed to pass June 2020  but it still taking June 20210 as data filter. Hope I provided detailed explanation,  please help me out how to get this resolved.

Sincerely,

Vamsikrishna.

Order ID	Order Date	Category
CA-2017-126221	12/30/2021	Ship Mode
CA-2017-143259	12/30/2021	Standard Class
CA-2017-119305	11/30/2021	First Class
CA-2017-116645	11/30/2021	Second Class
CA-2017-104136	11/1/2021	Same Day
CA-2017-104136	11/1/2021	Ship Mode
CA-2017-131632	10/31/2021	Standard Class
CA-2017-117114	10/31/2021	First Class
CA-2017-117114	10/31/2021	Second Class
CA-2017-128041	9/1/2021	Same Day
CA-2017-128041	9/1/2021	Ship Mode
CA-2017-159884	8/31/2021	Standard Class
CA-2017-159884	8/31/2021	First Class
US-2017-148362	7/1/2021	Second Class
US-2017-148362	7/1/2021	Same Day
US-2017-148362	7/1/2021	Ship Mode
CA-2017-102946	6/30/2021	Standard Class
US-2017-102890	6/30/2021	First Class
CA-2017-131695	6/30/2021	Second Class
CA-2017-110198	5/1/2021	Same Day
CA-2017-110198	5/1/2021	Ship Mode
CA-2017-151911	4/30/2021	Standard Class
CA-2017-144526	4/30/2021	First Class
CA-2017-144526	4/30/2021	Second Class
CA-2017-155712	3/2/2021	Same Day
CA-2017-124114	3/2/2021	Ship Mode
CA-2017-101959	2/28/2021	Standard Class
CA-2017-101959	2/28/2021	First Class
CA-2017-117212	2/26/2021	Second Class
CA-2017-151750	1/1/2021	Same Day
CA-2017-151750	1/1/2021	Ship Mode
CA-2017-160395	12/31/2020	Standard Class
CA-2017-160395	12/31/2020	First Class
CA-2017-100202	12/31/2020	Second Class
CA-2016-100671	11/1/2020	Same Day
CA-2016-129196	11/1/2020	Ship Mode
CA-2016-119165	10/31/2020	Standard Class
CA-2016-144218	10/31/2020	First Class
US-2016-142251	10/31/2020	Second Class
CA-2016-140130	10/31/2020	Same Day
CA-2016-116526	9/1/2020	Ship Mode
CA-2016-116526	9/1/2020	Standard Class
CA-2016-124583	9/1/2020	First Class
CA-2016-117408	8/31/2020	Second Class
US-2016-141544	8/30/2020	Same Day
US-2016-141544	8/30/2020	Ship Mode
US-2016-126431	7/1/2020	Standard Class
US-2016-158680	7/1/2020	First Class
CA-2016-162355	6/30/2020	Second Class
CA-2016-162355	6/30/2020	Same Day
CA-2016-135594	6/30/2020	Ship Mode
CA-2016-101525	5/1/2020	Standard Class
CA-2016-154788	4/30/2020	First Class
US-2016-120460	4/30/2020	Second Class
US-2016-151862	3/1/2020	Same Day
CA-2016-111283	2/29/2020	Ship Mode
CA-2016-101623	2/28/2020	Standard Class
CA-2016-102456	2/27/2020	First Class
CA-2016-101448	2/27/2020	Second Class
CA-2016-128706	2/27/2020	Same Day
CA-2016-153661	1/30/2020	Ship Mode
US-2016-166660	1/30/2020	Standard Class
US-2016-166660	1/30/2020	First Class
CA-2016-114944	1/30/2020	Second Class
CA-2016-168032	1/30/2020	Same Day
CA-2015-110814	12/5/2019	Ship Mode
CA-2015-110814	12/5/2019	Standard Class
CA-2015-149566	12/5/2019	First Class
CA-2015-149566	12/5/2019	Second Class
CA-2015-141740	11/1/2019	Same Day
CA-2015-131457	10/31/2019	Ship Mode
CA-2015-122259	10/31/2019	Standard Class
CA-2015-162537	10/28/2019	First Class
CA-2015-162537	10/28/2019	Second Class
CA-2015-162537	10/28/2019	Same Day
CA-2015-139290	10/26/2019	Ship Mode
CA-2015-156146	10/26/2019	Standard Class
CA-2015-156146	10/26/2019	First Class
CA-2015-156566	10/1/2019	Second Class
CA-2015-169201	9/28/2019	Same Day
CA-2015-169201	9/28/2019	Ship Mode
CA-2015-104626	9/1/2019	Standard Class
CA-2015-104626	9/1/2019	First Class
CA-2015-112319	8/31/2019	Second Class
CA-2015-111514	8/31/2019	Same Day
CA-2015-111514	8/31/2019	Ship Mode
CA-2015-153388	8/1/2019	Standard Class
CA-2015-153388	8/1/2019	First Class
CA-2015-124891	7/31/2019	Second Class
CA-2015-124891	7/31/2019	Same Day
CA-2015-124891	7/31/2019	Ship Mode
CA-2015-128860	6/29/2019	Standard Class
US-2015-141684	6/29/2019	First Class
CA-2015-165799	6/29/2019	Second Class
US-2015-100069	6/29/2019	Same Day
CA-2015-124919	5/31/2019	Ship Mode
CA-2015-124919	5/31/2019	Standard Class
CA-2015-124919	5/31/2019	First Class
CA-2015-100818	5/31/2019	Second Class
CA-2015-100818	5/31/2019	Same Day
CA-2015-104486	5/1/2019	Ship Mode
CA-2015-104486	5/1/2019	Standard Class
US-2015-164175	4/30/2019	First Class
CA-2015-135174	4/30/2019	Second Class
CA-2015-103716	4/30/2019	Same Day
CA-2015-103716	4/30/2019	Ship Mode
CA-2015-128125	3/31/2019	Standard Class
CA-2015-133494	3/1/2019	First Class
CA-2015-133585	3/1/2019	Second Class
CA-2015-133585	3/1/2019	Same Day
CA-2015-104052	3/1/2019	Same Day