Forum Discussion

cbold's avatar
cbold
Regular Visitor
8 years ago
Solved

Matrix custom subtotal

Hello,

 

I have a matrix which is filtered on page level by current year. The Rows are displaying various measures like profit last year, profit target current year and actual profit current year...  I put "MonthNameShort" from my date table into the columns to show those measures per month for the current year, which is working fine. 

 

 

What I would need is a extra column to show a cumulative total for each row, but only until year to month -1. Is this possible?

 

 

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    8 years ago

    Hi@ cbold 

    We can’t  add the Custom column into matrix . may be you could try to add the total into a table and align to the matrix.

    you could post your new idea in Power BI ideas and make this feature coming sooner .

     

     

    Best Regards,

    Lin

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    8 years ago

    Hi@ cbold 

    We can’t  add the Custom column into matrix . may be you could try to add the total into a table and align to the matrix.

    you could post your new idea in Power BI ideas and make this feature coming sooner .

     

     

    Best Regards,

    Lin