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