cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## 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!!

10 REPLIES 10
Super User

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.

Super User

@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.

Regular Visitor

@parry2k , thanks for giving me hope but please can you elaborate and help me more and share some example, in case you have one?

Super User

Where I come from we call that "sowing a button to your cheek".

Super User

@lbendlin That's my DAX special power! Lol!! 😛

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Super User

Not possible.  Use a separate visual or repurpose the row total.  (Don't name it Grand Total, that has a different meaning!)

Regular Visitor

Thanks.

Please can you explain, repurpose the whole total?

Super User

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)

Super User

@Ayush_Kar5 It's basically a variation of this: The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
Super User

@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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Fabric Community Update - August 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors