Forum Discussion

lherbert501's avatar
lherbert501
Post Prodigy
1 year ago
Solved

Drillthrough Help

Hi there,

 

In the below example, Is there a way to drillthrough on the homepage below from either of the two measures, to the destination page to show the sales ID's that are applicable?

 

I can't show the measures on the destination tablix, just the id's. I don't think this is possible without showing the measure on the destination page or a tab for each measure filtered, but I just wanted to clarify. PBIX link is below.

 

Is there a way around it somehow? Also, I have 15+ measures on my home page, all with different measures against different fields on my actual version.

 

Drillthrough.pbix

 

 

 

A) Home Page

 

B) Destination Page

 

Thanks

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi lherbert501 ,
    Thank you SamWiseOwl  for the helpful response!
    Since Power BI doesn’t currently support measure-level drillthrough cleanly when multiple measures are used on the same visual. I recommend posting  this idea in the Power BI Ideas forum. That way, the product team may consider adding support for drillthrough based on individual measures without needing a workaround.

    Hope this helps.If so,give us kudos and consider accepting it as solution.

    Thank you

    Regards,
    Pallavi.

7 Replies

  • SamWiseOwl's avatar
    SamWiseOwl
    Super User
    1 year ago

    Hi lherbert501 

    You could create a second measure to use on the drillthrough page:

    Hide Category Sales = If( CALCULATE(COUNT(Sales[Salesid]),Sales[category] = "IT"), " ", BLANK())
    Set the visual column aliase to a space and the column is effecitvely hidden:

    Or set it in the Filter Pane as a visual level filter that returns not blank.

    Then set this filter to hidden using the eye ball:

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi lherbert501 ,
    Thank you SamWiseOwl  for the helpful response!
    Since Power BI doesn’t currently support measure-level drillthrough cleanly when multiple measures are used on the same visual. I recommend posting  this idea in the Power BI Ideas forum. That way, the product team may consider adding support for drillthrough based on individual measures without needing a workaround.

    Hope this helps.If so,give us kudos and consider accepting it as solution.

    Thank you

    Regards,
    Pallavi.

    • lherbert501's avatar
      lherbert501
      Post Prodigy
      1 year ago

      Hi Anonymous ,

       

      Understood, thankyou for your response.

       

      Thanks

       

      Liam