Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Drilldown in a Matrix Table

Hi All

I have a matrix table only with Catgories (no measures or values) kind of hierachy and i would like to have a drill down when i clcik on any of the categories . Is there any work around for this?

Need Help
Tips and Tricks

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      i have some text fields say i have a  table  with columns A,B,C,D A,B,C Need to be displayed in hierarchy)and D need to be shown as drill down table when you click on B or C it will drill down to D  

       

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    Anonymous you should split this column into columns in PQ, what is the maximum depth? Like in the above case max is 4, although it doesn't matter, split function will take care of it.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Did you mean this drill down? You can refer to: Drill mode in a visual in Power BI.

     

     

    Please provide me with detailed screenshots about your problem.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.