Forum Discussion

PremaBoddeda's avatar
PremaBoddeda
Frequent Visitor
4 years ago
Solved

Drilldown in matrix columns

Hi All,

I want to have a drill-down option in columns while using matrix visualization. Is there any possible way to have it?

 

In rows, I'm able to see the dates but I want to see dates in columns under the respective column name. Can anyone suggest any other visualization like a matrix where we can drill down in columns? So please help me!

  • what you can do today is to select "drill on columns" and use the navigation icons (or right click the column header)

    What you cannot do yet is have the +/- icon for columns. If this is important to you please consider voting for the existing idea  at https://ideas.powerbi.com

  • lbendlin's avatar
    lbendlin
    4 years ago

    you can influence that via ISINSCOPE() to sense which hierarchy level is being displayed.

3 Replies

  • what you can do today is to select "drill on columns" and use the navigation icons (or right click the column header)

    What you cannot do yet is have the +/- icon for columns. If this is important to you please consider voting for the existing idea  at https://ideas.powerbi.com

  • PremaBoddeda's avatar
    PremaBoddeda
    Frequent Visitor

    Thanks for your help lbendlin.

    As I want to say that at the top level grouping should give count, but at lower levels, the actual date should appear

     

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User

      you can influence that via ISINSCOPE() to sense which hierarchy level is being displayed.