Forum Discussion

Narendra's avatar
Narendra
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Drill down feature on matrix, table visualization in Power BI Desktop

Hi All, Can we do the drill down feature on matrix ,table visualization in power bi desktop instead of Charts.   Regards, Narendra M
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
10 years ago

Hi Narendra,

 

No. We are not able to perform drill down action in a table or matrix visual.

 

The drill down feature needs hierarchies between fields. Because of the rendering mechanism of a table or matrix visual, those hierarchies can display completely when we drag those fields to a table or matrix. So we needn't to perform drill down action to see detail data.

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

  • LucianoVT's avatar
    LucianoVT
    Regular Visitor
    10 years ago

    Dear Qiuyun,

     

    Will this feature be available soon? we are planning a migration of dashboards from another visualization tool, and this feature is a must, almost all reports make extensive use of table drill-down.

     

     

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Icon for Community Support rankCommunity Support
      9 years ago

      You can vote and comment on this similar idea item: Matrix +/- Collapse/ Expand Buttons.

       

      If you have any question, please create a new thread. :smileyhappy:

       

      Best Regards,
      Qiuyun Yu

  • elz's avatar
    elz
    Icon for Advocate II rankAdvocate II
    10 years ago

    hello,

    i think that the person that posted the original question is referring to the "show levels" options in power view, which allow you to drill down on row and column matrix tables.

     

    i looked for this functionality in power bi desktop, but could not find it either.

    hopefully, this is being worked on, as an update in the near future, as matrix tables are popular.

     

     

     tracy

     

  • stuart_j_davies's avatar
    stuart_j_davies
    Regular Visitor
    9 years ago

    Hi, 

     

    Is it still current that we can't perform a drill down action in a table or matrix visual.

     

    For example I have a list of data displayed in a table. Then I want to click one of the items in the table and it takes me to a detailed report for that item. Is this possible? As this is a application I will be using PowerBI embeded.

     

    Stuart

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Totally agree on this!  We have a four level account structure that I'd really like to be able to drill on in a matrix visual.  Most users really only need the highest level of reporting but some do like to drill down for details.  The only way for me to accomplish this now with a matrix is to create separate pages.  However as I get down to account level three and four most of my screen real estate is taken up layering of account descriptions vs. actual data.

  • LucianoVT's avatar
    LucianoVT
    Regular Visitor
    10 years ago

    Dear Qiuyun,

     

    Will this feature be available soon? we are planning a migration of dashboards from another visualization tool, and this feature is a must, almost all reports make extensive use of table drill-down.