Forum Discussion

Richard_Halsall's avatar
Richard_Halsall
Helper IV
3 years ago
Solved

Matrix Totalling

Hi

 

I am attempting to replicate these 2 matrix visuals into a single matrix visual, keeping layout and the totals as shown i.e. no grand totals

Not sure if this is possible but any help will be appreciated. The sample pbi is here

 

Many Thanks

Need Help
  • kpost's avatar
    kpost
    3 years ago

    It's not exactly the same as your desired result but I added another column and put it on the matrix then fiddled with the display settings a little to add another layer of depth to the first column so they would group and total according to the way that you specified.

     

    https://files.catbox.moe/ry2btc.pbix

     

     

    //Mediocre Power BI advice, but it's free//

2 Replies

  • kpost's avatar
    kpost
    Solution Sage
    3 years ago

    It's not exactly the same as your desired result but I added another column and put it on the matrix then fiddled with the display settings a little to add another layer of depth to the first column so they would group and total according to the way that you specified.

     

    https://files.catbox.moe/ry2btc.pbix

     

     

    //Mediocre Power BI advice, but it's free//