- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Add Row at end of matrix visual showing % of grand total
I want to add an extra row at the end of the matrix visual (similar to grand total row).
Which will be showing the percentage of subtotal row divide by total.
For example in the below image:
I desire the yellow additional row in the Matrix visual of power bi. (By dividing the pink row (on time units) by blue row (grand total), to find the ontime %)
- One way is I add one more matrix visual and overlap, then group it to make one visual (but that I don't want to do)
- I want to create all the rows in just one matrix visual (Please let me know if it is possible ?)
Please note: the black outlined box in the image has already been achieved in matrix PBI Visual, I just want to add the yellow row in the matrix
Is there any other way in which I can add the yellow row in the Matrix Visual
Please comment, in case more details required.
I will be really grateful for the help!!
(Dear Super users, Please help me out or please show me the right direction)
@Greg_Deckler , @amitchandak @Ritaf1983 , @ryan_mayu , @lbendlin , @DataInsights
Thanks a lot in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

I am ok without it 😂 but then you don't want it to be answer for many problems
. 🙏
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@lbendlin Well I wouldn't say not possible. just need to recreate the data to achieve the desired result. I think the link @Greg_Decklershared has some solution, not had a chance to look at it though.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@parry2k , thanks for giving me hope but please can you elaborate and help me more and share some example, in case you have one?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Where I come from we call that "sowing a button to your cheek".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@lbendlin That's my DAX special power! Lol!! 😛
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Not possible. Use a separate visual or repurpose the row total. (Don't name it Grand Total, that has a different meaning!)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Thanks.
Please can you explain, repurpose the whole total?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

In a table visual each measure is calculated twice, once for the rows and once for the row total. You can use HASONEVALUE to distinguish between these scenarios, and return different results if you want. For example the row measure can return the sum of a value but the row total can return the average of these sums, instead of the total sum.
In a matrix visual a measure is calculated four times. Cells, row total, column total, and grand total (in the bottom right corner)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Ayush_Kar5 It's basically a variation of this: The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Ayush_Kar5 you have to basically create an extra row in the table for the total and then do the logic around that.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
Anonymous
| 08-01-2023 09:25 PM | ||
05-06-2024 12:44 PM | |||
08-13-2023 11:33 PM | |||
09-10-2024 03:20 AM | |||
10-18-2023 03:51 AM |
User | Count |
---|---|
141 | |
111 | |
81 | |
61 | |
46 |