Unlike few other data visualization tools such as Tableau or Qlik, for Power BI the cross filtering interaction across reports are limited to a single page, the only alternative being Drill Through, however that requires multiple clicks. I was trying to find out a way to recreate similar experience of cross filtering interaction across reports in Power BI.
Let me first show the end output, I have created a simple sales dashboard using some dummy data.
There are two pages Summary and Details,
And the interaction is present between the two pages. To illustrate that, let me select Product Category 'Furniture' from the top, and as expected other reports are showing for 'Furniture' only.
Let us try to explore the technicalities. I initially thought, this would be fairly simple using Bookmarks and Selections. I have created a single page with all the visuals, and have added a small empty section at the bottom.
Next I have performed 3 steps,
- Enabled the Bookmark and Selection view
- Hidden the Details table
- Created a bookmark called Summary
The same way I have hidden other charts to create another bookmark called Details.
Next I have added a Bookmark Button at the bottom and made it appear like tabs. And point to be remembered everything is in a single page.
To overcome this I have added a white shape, and instead of hiding / unhiding the Details table I am hiding / unhiding this white shape in the bookmarks.
So essentially my Details table is always visible it is the shape that is acting as a curtain.
And that does the magic of deception, it appears that we are cross filtering across two pages.
However, to emphasis this is not a full proof solution just a work around.
No comments:
Post a Comment