Report Redirection

[Anonymous]

Hi All,

I have three seperate pbix report

1) Sales Analysis Report ( having two pages i) Sales analysis page 2) filter page )

2) Inventory Analysis Report ( having two pages i) Inventory analysis page 2) filter page )

3) Finance Report ( having two pages i) Finance cost 2) filter page )

Each report contains a individual filter page.

Now, I need to consolidate the above three report with Table of contents. I have imported all the datasets of three reports and build a table of content using buttons and set navigation to respective pages, but i stuck up with filter pages. 

If i click '1) Sales Analysis Report' button in table of content , it will redirect the page to Sales Analysis Page, but how can i see the filter page of Sales Analysis Report. Each report has different filter pages and only the Sales Analysis filter page shloud be seen.

How can i overcome this ??

Thanks in advance....

[vanessafvg]

its hard to understand what you are asking, best thing to do is provide some screen shots of what it looks like with details explaining what you need.

[Anonymous]

Hi @vanessafvg 

In the above screenshot, I have developed three reports. Just I need to know, whether we can connect these three reports using hyperlinks or any other options. 

I have a new pbix report having a Table of Content as follows,

1) Consolidated Sales Analysis Report.

2) Detailed Sales Analysis Report.

3) Sales Comparison Report.

Now, when i click ' 1) Consolidated Sales Analysis Report ' in the Table of content, it should be redirected to that particular report. Note that each report have multiple pages. When its redirect, it should be able to show all the pages in Consolidated Sales Analysis Report.

[vanessafvg]

have you tried to do the cross report drill through?

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