Power BI Drillthrough multiple parameters

[harshaSampath81]

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

[v-jiascu-msft · Accepted solution]

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

[harshaSampath81]

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-msft]

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

[freder1ck]

Another workaround is to resize the column to have no width. If word wrap is on, this will make the rows wider.

[harshaSampath81]

Thanks Mr frederick