Forum Discussion
Power BI Drillthrough multiple parameters
Hi
I want to know how to send two parameter when do drillthrough reporting ex:
Here I want to send Product category , year and Month to next report and filter my second report according to selected my Product category , year and month. how to do that. current I can filter by Product category only.
Harsha
Hi Harsha,
The workaround is adding the Year and the Month to the Drill through filter and the table. Then you can deliver two parameters at one time. Please vote on this idea. Maybe we can send the page context in the next release.
Best Regards,
Dale
5 Replies
- v-jiascu-msftMicrosoft Employee
Hi Harsha,
The workaround is adding the Year and the Month to the Drill through filter and the table. Then you can deliver two parameters at one time. Please vote on this idea. Maybe we can send the page context in the next release.
Best Regards,
Dale
- harshaSampath81Helper II
Thank you very much Dale , I tried this one it was success, but I need to hide unwated column from the table (becuase that year,month are used in the table for drillthrough) Do u have any idea of how to hide column without effect to drillthrough.
thank you
Harsha
- v-jiascu-msftMicrosoft Employee
Hi Harsha,
I'm afraid there isn't a perfect solution. That's why I gave you an idea to vote on. A workaround could be painting them white.
Best Regards,
Dale