Forum Discussion

mshao's avatar
mshao
Icon for Helper III rankHelper III
2 years ago
Solved

Custom the subtotal name in Matrix

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, an...
General Comment
Need Help
Show and Tell
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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's avatar
mshao
Icon for Helper III rankHelper III
2 years ago

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's avatar
Ritaf1983
Icon for Super User rankSuper User
2 years ago

 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's avatar
    mshao
    Icon for Helper III rankHelper III
    2 years ago

    still a lot of thanks!! Thank you so much