Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to remove extra page name under drill through option

I am using drill through functionality for multiple pages(Keep all filter option is enabled as per my requirement).I want to show only specific pages under drill thourgh.

Below is screenshot showing multiple pages under drillthrough.I only want to show reuired page names.

 

Please help.

 

 

  • Hi Anonymous ,

     

    One way to achieve this,that is to make the drillthrough function unavailable by keeping the drillthrough field blank in the pages that you dont wanna drillthrough.Or you can set different drillthrough fields on different drillthrough pages to make drillthrough more efficient.

     

     

     

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

3 Replies

  • Mariusz's avatar
    Mariusz
    Icon for Community Champion rankCommunity Champion

    Hi Anonymous 

     

    I'm afraid drillthrough will always display all available options, there is no way of adjusting, the new functionality that combines drillthrough buttons and destination pages could be an option here.

    https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2020-feature-summary/#_Cond_dest_drill  

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

     

    One way to achieve this,that is to make the drillthrough function unavailable by keeping the drillthrough field blank in the pages that you dont wanna drillthrough.Or you can set different drillthrough fields on different drillthrough pages to make drillthrough more efficient.

     

     

     

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
  • Anonymous's avatar
    Anonymous
    Not applicable

    I was having a similar issue, when we right click the ACTIVE bar we get two options for drill down, and if the user then clicks the INACTIVE option, they get the ACTIVE tab, but all the values are blank.  What we want is to right click the ACTIVE and get one option and that takes you to the Active tab.  I was able to solve the issue by having one drill down tab.  On what was the ACTIVE tab, I elimintaed the Active filter.  The drill through functionality does the filtering on the field you specify, so I only needed on tab.  

     

    In your case, I would eliminate all but one of the drill down tabs and then, on the one remaining drill down tab, I would remove the filtering on the field that you are drilling down from (in your case I believe that is the 'analyze' field).  You may have to think about the design of that tab, but that's the way I was able to solve that issue.