Hey!
I managed to create a way to drill through to multiple pages without having the user obliged to select a particular element in a visual, or with the user selecting multiple elements from multiple visuals.
Assume you have your drill though pages, say names page1 till page4, and you have your report home page summarizeg your data.
Normally to drill through from home page to any page, you have to right click on a visual element, exactly one, then choose the page you want to go to.
Alternatively, you can add in your fact table a calculated column, named "Drill" with a constant value, say =1.
Now you can add this column to a card visual (the new card visual), disable the value, and type "Right click to drill through" in the value label, or any other text you see suitable. This will do the job!
You can also use the pie chart visual and put the Drill column in the values and legend (to be able to choose a color) and enable drill through on click from the format menue (not right click). It worked on PBI desktop, but unfortunately when I published the report, did not work on the service!
Two comments here: you can zero the paddings and shrink the pie chart to a button size. Also make sure in the values aggregation you choose min, max or average, but never use sum or count, because as you choose elements from other visuals, the pie size will shrink 😄. You can also use a treemap if you want a rectangular shape.
Hope this helps someone 🙂
