Matrix SubTotal

[Anonymous]

Hi Team,

Ineed to show Weekdaywise subtotal, kindly help me.

I don't want red strickout total, expected Weekday subtotal, highlighted Yellow color.

Thanks,

Kalidass

[parry2k]

@v-henryk-mstf how your reply is different than mine. If users have not replied to my post I guess you have to wait to answer until he replies back. I don't see the point for you to answer the post??

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

According to your description, you need to set up the appropriate settings in Format. Change "Row subtotal position" to Bottom, then turn on per row level, and select the button corresponding to the Weekday field to turn on.

You can also read related blog as below:

Making Sense Of Subtotals Settings In The Power BI Matrix Visual — ehansalytics

If the problem is still not resolved, please point it out. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous you can customize row total on format pane by turning on Per Row Level and then use whatever level you want the total and turn off at other levels.

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡