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
Chaitanyak999
New Member

Unable to display Totals for recently added column in Power BI Table visual.

In the table visual, I'm using multiple columns, including an amount column. Previously, when hoivering the mouse in the column section visualizations pane, the column name was displayed as ''Sum of TableName.ColumnName. I added the same column again, but now it's only showing the TableName.ColumnName. I'm unable to see the totals for the recently added column. What is the issue, and how can i enable totals for the recently added column? I have already enabled the Totals option in the format visual.

Thanks in advance.

Chaitanyak999_0-1719943204051.png

Chaitanyak999_1-1719943369744.png

 

Chaitanyak999_2-1719943491103.png

 

2 REPLIES 2
prudvit
Frequent Visitor

Is Amount A Formatted Correctly, I am assuming that it is a text value - try and reformat it as Decimal or Integer so appropraite value is returned

PijushRoy
Super User
Super User

Hi @Chaitanyak999 

I am not able to reproduce the issue. 
You told that you are using the same column two times, one is taking the sum and the other is not showing the sum. Please check again
Please select the column and turn Summarization to Sum

PijushRoy_0-1719944292192.png

 



 


Let me know if that works for you


If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!





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.