I have developed let’s say 20 Power BI packages/apps and each of them have at least 3 reports in it, so roughly a total of 60 reports.
Now, I want to embed that to a website with the scrolling capability. I am facing issues in that. Can someone please help me with that?
Here’s an overview of the problems.
To get the scroll we will have to stack power bi packages down the page. So when you click on Account Details the page will load its 3 reports/tabs- Calls, Payments, Portal as 3 separate embedded reports. This causes 2 main issues:
The filtering issue:
Because the 3 reports are now separated (not in the same package and navigated through the use of bookmarks) each one would have its own filters that are not affected by others.
The View/Click inflation issue:
Let’s say that a client wanted to see how many texts we sent out yesterday. Currently, they would open the Account package and then click the Call page. This would load 1 package and be treated as 1 click/view because Call is within the Account detail package.
With the scrolling concept, the user would click on Account Details and then we would load all 3 individual reports (Calls, Payments, Portal) at the same time which would count as 3 clicks/views.
Along with this, to accomplish the filtering issue above I would have to reload the reports with the updated filter selection so in this example every time someone changed the service location, physician, etc you would get 3 more click/views. Also, the reload might be annoying if you’re constantly filtering to find certain metrics.
Have someone done something that can help me sort this filtering issue to work on all pages or different packages. Also for the record, I will be just using Filter Pane to filter data and no slicer will be on a page/report/tab.