Need help with cross report navigation

[dbritoprime]

Hello guys,

Just for a quick overview, we are setting a set of new BI panels for the company. There will be around 20 different sectors and we thought about having a Home Screen that would lead to all these different reports.

We can't use a single .pbix file, there's no way the team would manage to work in the same file with over 100 pages, so we need this home screen to have a cross report navigation. 

We tried to use URLs, but this causes the browser to always open a new tab, we then tried to set drill through buttons to cross reports, but we didn't manage to make this work properly. 

Can anyone give us any help with this? 

A way to open this URL in the same tab or how to make the cross report drill through with buttons work properly

thank you

[Piotrrekk]

Hi,
Refreshing this therad just to check if there was any better solution implemented in Power BI to solve cross report connection?

[amitchandak]

@dbritoprime , URL will open in a new window. I doubt there is option give to open it same window.

what is the issue with cross-report drill-through? Hope dataset is the same, and the properties, shown below are taken care off

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through

[dbritoprime]

The problem with drill-through is that we couldn't find a way that the button will always have the same value and it's just clicking in it. We managed to work by having a table where the user clicks in the sector name and then the button works. 

We wanted a page where every button is also the sector icon, the user clicks on the icon and goes to the report. Just like if it was an app home screen

[v-deddai1-msft]

Hi @dbritoprime ,

Could publish all these reports in a same workspace and create an app for them be a workaround? As far as I know, if you use button to naviagte to the new page, it doesn't support cross-report.

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

Best Regards,

Dedmon Dai