Forum Discussion
Sync Drill downs
I have several Matrix visualisations with the same product hierarchy, all the data is the same they just have different time period filters (week to date, month to date, year to date...). What I want to be able to do is drill down on the product hierarchy, from Category to Brand, on the week to date Matrix and for all the other Matrix to do the same drill down at the same time
Is there a way to synchronise the drill downs across the 4 Matrix visualisations?
I know I could create measures for the time period and put them all in one big matrix, but there are already a lot of measures and it is already at risk of becoming too large to fit in the available resources
3 Replies
- JohnKNisAdvocate II
Thanks djurecic I have voted for it, looks like there are several other ideas for the same thing so i might even get done a some point
https://community.fabric.microsoft.com/t5/Fabric-Ideas/sync-drill-down-across-visuals/idi-p/4516765
https://community.fabric.microsoft.com/t5/Fabric-Ideas/Sync-drilldown-between-visuals/idi-p/4530747
https://community.fabric.microsoft.com/t5/Fabric-Ideas/Sync-Drill-Down-Multiple-Charts/idi-p/4500946
- Shahid12523Community Champion
Power BI can’t auto-sync drill-downs across Matrix visuals.
Workarounds:
Field parameter + slicer → controls hierarchy level for all matrices.
Bookmarks/buttons → preset levels (Category, Brand, Product) applied to all.
Or use one matrix with a Period slicer (WTD/MTD/YTD).
No direct “click one, all sync” option.