Forum Discussion

dbldee5's avatar
dbldee5
Frequent Visitor
1 year ago
Solved

PBI Matrix Help

Can anyone help, I am trying to get my matrix from showing two total lines. I need all the subtotals, then just one Course total at the end.. Also, instead of making it say Course Total, can I make i...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi dbldee5 ,

     

    As far as I know, currently Power BI doesn't support us to show dynamic subtotal name by measure.

    However, we can DIY the subtotal for each level.

    Row subtotals > Turn on "Per row level" > Select the level you want to change in "Row level"

    Result is as below.

    If you want to turn off the subtotal of which level, you can select the level and turn off the subtotal.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.