Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
mshao
Helper II
Helper II

Custom the subtotal name in Matrix

Hi Team,

 

I have original data like this:

mshao_0-1719816666897.png

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:

mshao_1-1719816838808.png

But I want my report to show like this:

mshao_2-1719816862005.png

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

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

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.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

7 REPLIES 7
v-fenling-msft
Community Support
Community Support

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:

vfenlingmsft_0-1719899604146.png

 

 

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.

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?

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
Super User
Super User

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.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

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?

 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.

 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

still a lot of thanks!! Thank you so much

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.