Add a total row after two rows of a matrix

[Gianluca_Colett]

Hello,
I would like to be able to add a row after the two rows named 'Ricavi' and 'Costi Esterni Diretti' that sums the values of the latter (a subtotal). How is it possible to do this? I have been trying for quite some time without succeeding. Considering that the field 'Voci LV 1' is part of a table related to another to take the value of the field 'Importo'.
Thanks to those who will help me!

[amitchandak]

@Gianluca_Colett , You need to have those as additional values in the dimension table or extended dimension table

Refer blog: https://medium.com/microsoft-power-bi/power-bi-formatted-p-l-with-custom-sub-totals-and-blank-rows-e...

Power BI How to get the P&L formatting right: https://youtu.be/C9K8uVfthUU
Power BI How to get two columns format Profit and Loss Statement(P&L) right: https://youtu.be/WLg85yiMgHI

[Gianluca_Colett]

Isn't it possible to do such a thing without going to Excel to edit the table? But to do everything in Power BI in an easier way?

[Anonymous]

Hi @Gianluca_Colett ,

For this case, it is more recommended that you use visual objects such as cards. Because you can't just add data for these two rows in the matrix, in which case the other rows will also be involved in the calculation.

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[Gianluca_Colett]

Yes with the cards I can display the desired values, but I would like some trick to be able to handle the subtotals, without having to go through Excel, since I get the data via an import from a SQL server.