Forum Discussion

harshaSampath81's avatar
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 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.

    Power_BI_Drillthrough_multiple_parameters

     

     

    Best Regards,

    Dale

5 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft 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.

    Power_BI_Drillthrough_multiple_parameters

     

     

    Best Regards,

    Dale

    • harshaSampath81's avatar
      harshaSampath81
      Helper 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-msft's avatar
        v-jiascu-msft
        Microsoft 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.

        Power_BI_Drillthrough_multiple_parameters2

         

        Best Regards,

        Dale