Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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..
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....
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |