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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

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.