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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Nihed
Helper III
Helper III

Help

Hello,

please someone can help me on the table display I wanted to put the total online and not in column?

I want to display the total of each quarter.

 

Nihed_0-1645230766001.png

 

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Hi @Nihed ,

 

You can get the same format pane by enable the "New format pane" preview feature and then you can find the same options like @tackytechtom.



Icey_0-1645499097737.png

 

And for the format pane you are using currently, you can find that option here:

Icey_1-1645499753271.png

 

And based on your screenshots, I guess you are using the feature of "Show on rows". Right?

Icey_2-1645499870641.png

Icey_3-1645499893003.png

 

If so, the simplest method is to create total measure manually like so:

Measure Total = [Measure 1] + [Measure 2]

Icey_4-1645499996141.png

Icey_5-1645500020669.png

 

 

 

Best Regards,

Icey

 

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

View solution in original post

6 REPLIES 6
tackytechtom
Super User
Super User

Hi @Nihed ,

 

What PBI version do you have? You can find the version under File > About (at the very bottom)

I have this one:

tomfox_0-1645297374437.png

 

/Tom

https://www.tackytech.blog/

https://www.instagram.com/tackytechtom/

 



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

I have the same version as you

 

Nihed_0-1645297724056.pngNihed_1-1645297752353.png

this is what is displayed 😕

Icey
Community Support
Community Support

Hi @Nihed ,

 

You can get the same format pane by enable the "New format pane" preview feature and then you can find the same options like @tackytechtom.



Icey_0-1645499097737.png

 

And for the format pane you are using currently, you can find that option here:

Icey_1-1645499753271.png

 

And based on your screenshots, I guess you are using the feature of "Show on rows". Right?

Icey_2-1645499870641.png

Icey_3-1645499893003.png

 

If so, the simplest method is to create total measure manually like so:

Measure Total = [Measure 1] + [Measure 2]

Icey_4-1645499996141.png

Icey_5-1645500020669.png

 

 

 

Best Regards,

Icey

 

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

tackytechtom
Super User
Super User

Hi @Nihed ,

 

tomfox_0-1645260039720.png

 

First take the matrix visual and drag in the fields accordiingly:

tomfox_1-1645260074117.png

 

After you can choose which totals you would like to display by using the toggles:

tomfox_2-1645260145935.png

 

Hope this helps 🙂

Tom

https://www.tackytech.blog/

https://www.instagram.com/tackytechtom/

 



Did I answer your question➡️ Please, mark my post as a solution ✔️

Also happily accepting Kudos 🙂

Feel free to connect with me on LinkedIn! linkedIn

#proudtobeasuperuser 

Hello ,

 

Thank you for your return.

Unfortunately, I can’t do it I don’t have this option in the power BI.

You can update now to the new version. I just updated mine yesterday

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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