Hi Experts,
I want to show table that is identical to given screen shot. is there any way to show multiple rows in Final total like that?
Thank you in advance...
Waiting for your reply.
Hi @Uzi2019 ,
Theres is no such option to make the visualization has you are placing it here.
You can have two option one is to create tow table with different groupings and then make one on top of the of the other.
Other option is to create dimensiont table and measure that agregate the information has your need but believe that having so many diffent options that will cause a big increase in your model.
The only change was that I added a column to the model sayning Total as the first level of thesecond table.
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português
Hi @Uzi2019 ,
Theres is no such option to make the visualization has you are placing it here.
You can have two option one is to create tow table with different groupings and then make one on top of the of the other.
Other option is to create dimensiont table and measure that agregate the information has your need but believe that having so many diffent options that will cause a big increase in your model.
The only change was that I added a column to the model sayning Total as the first level of thesecond table.
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português
Helpful resources
Join our Community Sticker Challenge 2026
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Power BI Monthly Update - January 2026
Check out the January 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
| User | Count |
|---|---|
| 65 | |
| 64 | |
| 45 | |
| 21 | |
| 18 |
