Custom the subtotal name in Matrix

[mshao]

Hi Team,

I have original data like this:

I created a matrix in Power BI Desktop to show total value in SubType and Type  and all level. I put Type、SubType、ID in row and value in column, and I set the display of subtal then  I get this report:

But I want my report to show like this:

How can I achieve my goal? Do you guys have any idea? Thanks.

[v-fenling-msft]

Hi,@Ritaf1983 

thanks for your concern about this issue.

Hi,@mshao 

I am glad to help you. 

According to your description, you want to custom the subtotal name in Matrix? 

If I understand you correctly, then you can refer to my solution. 

I'm sorry to tell you that you will not be able to achieve this result by the method you described. Adding a new row to the hierarchy is not supported in Power BI. But you can use another method to get the result you want. 

After importing the data into Power BI Desktop, you can use the matrix directly and change the value to Sum of Value to get the result you want. 

Here are the test results, with totals for types A,B, and subtotals for their corresponding subtypes:

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,
Fen Ling,

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

[mshao]

Thank you so much for your kindly reply, but that's no what I want, I want to get the custom subtotal name for different type.Do you have any idea?

[v-fenling-msft]

Hi, @mshao 

Unfortunately, I have not found a way to customize subtotal names for different types at this time.

If you find a counterpart, please share your solution and also accept it as a solution. This will benefit members of the community who are experiencing the same problem as you to be able to find a solution quickly.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Ritaf1983]

Hi @mshao 

It is possible with a disconnected table and dynamic measure.

Please refer to the linked video :

https://www.youtube.com/watch?v=mUVz59xCRMI

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

[mshao]

Thank you so much for your kindly reply, but that's too complicated and my case is not so complicated, is any simple way to achieve what I want?

[Ritaf1983]

 Hi @mshao 
That's the life of a developer: to create something simple, we have to put in a lot of effort 🙂

Unfortunately, if you need to dynamically generate custom headings for subtotals I'm not aware of any other options.

[mshao]

still a lot of thanks!! Thank you so much