Linking drill down across visuals?

[mrothschild]

On my report, I have each an Income Statement and Balance Sheet in Matrix visuals, as well as some Bar Charts, in which each of them I can drill up/down the columns via date hierarchy to Year, Quarter, and Month.  Is there a way to link them so that if I drill down from Quarter to Month on one visual, e.g., the Income Statement, it will drill down everything else?  I believe this is different than the drillthrough function and also doesn't seem to work with Edit Interactions on teh Format menu tab.

[yerdaman]

https://www.wiseowl.co.uk/blog/s2567/drill-down-filter-visuals.htm

[v-yuta-msft · Accepted solution]

@mrothschild ,

I'm afraid that drill down/up doesn't support this. You can only drill down/up in the same visual. As a workaround, you can use drill through. Create a page2, then create a same visual and drag the date column in the drill through field. 

Then in page1, right click on chart, select drillthrough-> page2, then you can click the month column in chart in page1, this will filter the chart in page2, for more details, please refer to: 

https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Kind of astounded there's no way to do this without hacky workarounds. Have there been any advancements on this since 2019? Or is there a way to raise a feature request. Seems like it should be available.