matrixpowerbi

Hot to get subtotal only for one column in Power BI Matrix

I am creating a matrix with three categorical columns: Group1, Group2 and Group 3, and one numeric column.

What I need is to turn off the subtotals for columns Group 2 & Group 3, and only keep the subtotals for Group 1.

How would I achieve this in Power BI matrix?

enter image description here

Here is the PBIX file: https://filebin.net/koop431qipg2qr55

Solution

  • under the row subtotal, turn on the per row level, select group 3 and turn off show subtotal

    and do the turn off the row subtotal for group 2 as well.

    enter image description here