The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
If I click on Resturants on the bottom graph, can I have the above graph only show relevant data to my current filter in the bottom graph?
I dont know if rebuild is the right word. Essentially, if I click on a Category in the bottom chart, I'd like the first chart to only show the Description relevant to the Category instead of still showing all Descriptions for all category and just fading the nonrelevant ones.
Hi J_A,
Drill through can meet your requirement, please refer to this documentation:
https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough
Regards,
Jimmy Tao
you can decide the cross-filter behaviour under the “edit interactions” option in the FORMAT option in the main ribbon. Select the visual you want to act as the filter, then go to “edit interactions” and choose the “filter” icon on the target visual.
Proud to be a Super User!
Paul on Linkedin.
it solves my concern
If I click on Resturants on the bottom graph, can I have the above graph only show relevant data to my current filter in the bottom graph?
I dont know if rebuild is the right word. Essentially, if I click on a Category in the bottom chart, I'd like the first chart to only show the Description relevant to the Category instead of still showing all Descriptions for all category and just fading the nonrelevant ones.
User | Count |
---|---|
68 | |
63 | |
59 | |
54 | |
28 |
User | Count |
---|---|
182 | |
81 | |
63 | |
47 | |
41 |