Forum Discussion
Peter_Jeyaraj_I
Helper II
7 years agoDynamic filter for last 12Months based on another visual
Hi All, I have a KPI trend for rolling 12 months like below ( 201901 would include the value from 201802 to 201901). Now, my request is if i select 201901 in the top graph, then i want to see ...
v-danhe-msft
Microsoft Employee
7 years agoHi Peter_Jeyaraj_I ,
From your description, I could not understand "if i select 201901 in the top graph, then i want to see only the related 12 months in the bottom graph"
It seemed the top graph is a line chart, could you mean to select the data point in 201901 and show the related data in bottom chart? If so, based on my researh, maybe you could achieve this feature in different pages by using drillthrough function:
https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough
http://radacad.com/master-detail-design-with-drillthrough-filter-in-power-bi
Regards,
Daniel He