Forum Discussion
Richard_Halsall
3 years agoHelper IV
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 hel...
- 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//
kpost
3 years agoSolution Sage
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//
Richard_Halsall
3 years agoHelper IV
Many thanks for your assistance