Forum Discussion

po's avatar
po
Icon for Post Prodigy rankPost Prodigy
7 years ago
Solved

Cross report drill

Hi,

 

Was looking at website below.

 

https://docs.microsoft.com/en-us/business-applications-release-notes/April19/business-intelligence/planned-features

 

Looking for following functionality

 

scorecard matrix with measure names across top and values in the matrix itself

 

and when click on one of teh columns can go to a separate .pbix report specifically for that measure with filters already applied.

 

I'm wondering if the above website link mentioning cross report drill will give this fucntionality and when will be available for release and/or alternativce ways of accomplishing similar.

 

Thanks

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi po 

    The link says we will support filter context to apply to to the destination report.

    Currently, we could drillthrough from one report to another report according to this article

    https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough

     

    However, it supports for the same pbix files. You could create many reports in a pbix file.

     

    Per your requirements, you want a separate .pbix report( different pbix file?) to drillthrough to.

    If so, there is no official document regarding this.

     

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi po 

    The link says we will support filter context to apply to to the destination report.

    Currently, we could drillthrough from one report to another report according to this article

    https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough

     

    However, it supports for the same pbix files. You could create many reports in a pbix file.

     

    Per your requirements, you want a separate .pbix report( different pbix file?) to drillthrough to.

    If so, there is no official document regarding this.

     

    Best Regards

    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • po's avatar
      po
      Icon for Post Prodigy rankPost Prodigy
      7 years ago

      Hi,

       

      Thansk for update.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      v-juanli-msft 

      Unsure if I am reading this right but...

      I have one PowerBI file that has data at a monthly level.

      I then have a seperate PowerBI file that is exactly the same but now has a weekly element/breakdown in the dataset (ie is 4 times bigger)

       

      Reason for seperating is data size was causing performance issues. 

      Can I drill through from the monthly to the weekly? 

      I cant seem to get it to work