Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Matrix Visual drill down from value grand total

Hi,

 

I'm trying to build a matrix with multiple measures on rows, with ability to drill down from them instead of first dimension I've placed on rows.

 

On the left my matrix, on the right what I'm trying to achieve. My intention is to put several more measures and add calculation groups on columns to show different time period.

 

 

 

 

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hello

     

    I managed to solve it myself, by creating disconnected table with name of each measure and corresponding ID, and then using SWITCH function.

     

2 Replies

  • This may not be possibe under rows. It can be done under columns.

     

    Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.

    Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

    https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello

       

      I managed to solve it myself, by creating disconnected table with name of each measure and corresponding ID, and then using SWITCH function.