Forum Discussion

mshao's avatar
mshao
Helper 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.

Ritaf1983's avatar
Ritaf1983
Super User
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
Helper 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
    Super 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
      Helper III
      2 years ago

      still a lot of thanks!! Thank you so much