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
TIA
I have 2 matrix visuals hich have a hierarchy of quarter and period placed in the column sectionand both are present in the single page. I want if I drill one of the visula then the other visual shuld also respond to the same.
I have 2 queries:
1. Can this thing happen in PowerBI and if yes then how?
2. Can this same feature be applied to the visuals present on the different pages and if yes then how?
Regards,
Hi @singh_gagan30 ,
is your problem solved?
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Hi @singh_gagan30 ,
check out the post below.
SaadXPO creates a filter to simulate a drillthrough.
You can use this on several visuals.
Regards,
Marcus
Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
Hi,
You cannot drill down into multiple visuals at the same time.
Without seeing what you are working on my only suggestion would be to add some splicers to filter your data and potentially add the data you want to drill to as columns. That way the splicer would filter out the columns until you selected (or deselected) them giving a similar result.
As for doing it across multiple pages, you can link visuals to each other or add filters that apply to all pages. This is my only thought to do this simply. The other option is to create dynamics measures on the other pages based on the main page, but for this we would need to see your data and it sounds like more work than it is worth.
@singh_gagan30 unfortunately it is not possible, it will not auto drill to 2nd visual but it will filter data on 2nd visual.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |