Dynamic filter for last 12Months based on another visual

[Peter_Jeyaraj_I]

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

[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_I]

Hi, 

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.. 

[Ashish_Mathur]

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-define....

[v-danhe-msft]

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