Luca has attended:
Power BI Reporting course
Drillthrough
I have a generic dashboard with a table in it that summarises the monthly variances of the cost categories.
I have then created sperate reports for each of these cost categories, which go into more detail.
The users can therefore right click on the table and select the page they want to see from the drill through list. However, I have noticed that the drill through only works correctly when I right click on the relevant line item I want to see.
i.e. if I right click on staff costs, but select Technology from the drill through list, it takes me to the staff costs report but applies tech data.
Any way I can stop this from happening?
Thanks,
Luca
RE: Drillthrough
Hi Luca,
Thank you for the forum question.
I have tested this myself and also done some Googling. Unfortunately it doesn't look like I can help you with this.
I don't think there anyway of doing what you want.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector