Forum Discussion
Helper IIDynamic 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 only the related 12 months in the bottom graph
By default, it has to show all months in the below graph. Please share your suggestion to fix this.
thank you
4 Replies
v-danhe-msftMicrosoft Employee
Hi 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
- Ashish_Mathur
Super User
Hi,
See if my solutio here helps - http://www.ashishmathur.com/flex-a-pivot-table-to-show-data-for-x-months-ended-a-certain-user-defined-month/.
- v-danhe-msft
Hi Peter_Jeyaraj_I ，
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?Regards,
Daniel He
Peter_Jeyaraj_IHi,
Nope, i tried with above responses and still i may need to apply one more filter separately for month. But i want to use the above graph as a filter and it's not working..
Anyhow, it's not resolved.. let's c..
