Forum Discussion
SameperoidLastYear Drillthrough
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
2 Replies
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