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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
alam
New Member

total column seperated by months

Hello,

 

Im new to powerbi. I have a table with work hours and I have made a "total" column at the very end to show the SUM for each staff.

 

The data is displayed by month and date VS staff, however, is it generating a "total" column at the end of each month. Is there a way to remove that? 

 

 

1 REPLY 1
Sean
Community Champion
Community Champion

No unfortunately this is not possible although it should be!

Sounds like you have a Matrix Visual with 1 field in the Rows and 2 fields in the Columns.

When you go to the Subtotal Options of the Matrix you can turn on and off both Row Subtotals and Column Subtotals

However this also affects the Grand Total Row and/or the Grand Total Column but it should NOT !

You should be able to turn on/off only the Grand Total Row/Column independent of the Row/Column Subtotals.

Vote for this Idea! And hopefully they'll add the option soon Smiley Happy

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13185840-please-provide-a-way-to-...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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