Forum Discussion
Adding Grand total Column to Matrix
Hi together!
I'm trying to create a Report which includes Grand total column as below:
Could you please help me if this is possible!
Thank you!
duycao ,
I'm afraid the grand total text can not be modified currently. As a workaround, you can try custom matrix visuals like below:
https://www.youtube.com/watch?v=NKeKP5lOilk
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi duycao , Add Sub total Male & Sub total Female columns in card visual if it present in your model and resize as you need and add text box on top of your matrix visual.
duycao ,
Have you tried matrix visual in power bi desktop?
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Jimmy,
I've been trying Matrix in Power BI. What am I trying to do in your example is adding a Total area of all Categories on the Top (or on the Bottom) of the Matrix, which also includes the detail of Subcategory under that, as below
Audio
- BT headphones
- MP4&MP3
...
Camera & Camcoder
- Camcoder
- Camera
....
Total Category
- BT headphones
- MP4&MP3
- Camcoder
- Camera
Thank you for your help
duycao ,
I'm afraid the grand total text can not be modified currently. As a workaround, you can try custom matrix visuals like below:
https://www.youtube.com/watch?v=NKeKP5lOilk
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
