Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Uzi2019
Super User
Super User

Multiple Rows in a Final Total

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?

Uzi2019_0-1604992284103.png

 

Thank you in advance...

Waiting for your reply.

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
1 ACCEPTED SOLUTION
MFelix
Super User
Super User

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.

 

MFelix_0-1605022373230.png

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



View solution in original post

2 REPLIES 2
MFelix
Super User
Super User

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.

 

MFelix_0-1605022373230.png

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



@MFelix Thank you for your reply. Option for 2 different table works for me.

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

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.