Hi,
I need some help with setting up some of our reports. Up till now, there has been a report by region (with completely different datasets and sources, but with a somewhat equal design and final KPIs). This means we've had almost copy-paste reports with different sources for each region and multiple pages with all the details.
I tried to re-structure the data to append it but it appears this is not an option, as management prefers an app-like experience and not a filter where they can choose the region they want to see. Again this would be a challenge to have all the data in the same table as each country has a completely different fact and dimension table structure.
I am trying to find a way to allow users to navigate from one report to another using a button, to give them an 'app' like experience. So there is a page with a summary with the main KPIs where they can choose the country they want to see, click, and then they are in the full report with all the details and pages, without the need to have a single report with +15 pages or a filter to choose a region.
So they feel like they are in one report but it actually spans multiple, so they could have the more granular experience where if they want to deep dive into one country they got all the details in one report and if they don't they still got the summary.
Kind regards,
Edit: I think maybe Power BI Apps is the solution for this. As I see it allows me to have multiple reports in the same space allowing for cross-report navigation. I still have some doubts about how it relates to cross-report drill through and if it can be enabled at all. Link: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-create-distribute-apps
