Forum Discussion
Linking drill down across visuals?
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.
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.
3 Replies
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.
