Forum Discussion

harshaSampath81's avatar
harshaSampath81
Icon for Helper II rankHelper II
8 years ago
Solved

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 accor...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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.

    Power_BI_Drillthrough_multiple_parameters

     

     

    Best Regards,

    Dale

harshaSampath81's avatar
harshaSampath81
Icon for Helper II rankHelper II
8 years ago

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's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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.

Power_BI_Drillthrough_multiple_parameters2

 

Best Regards,

Dale

 

  • freder1ck's avatar
    freder1ck
    Icon for Kudo Kingpin rankKudo Kingpin
    8 years ago

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

    • harshaSampath81's avatar
      harshaSampath81
      Icon for Helper II rankHelper II
      8 years ago

      Thanks Mr frederick