cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Peter_Jeyaraj_I
Helper I
Helper I

Dynamic 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

 

pbi_doubt.JPG

 

 

4 REPLIES 4
v-danhe-msft
Microsoft
Microsoft

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
v-danhe-msft
Microsoft
Microsoft

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

 

 

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!