Ho do I remove the Column Subtotals for certain fields in the Matrix visual in power Bi.

[KanikaU]

Hi Everyone,

I am new to Power BI.

I am strugling with the formating in Matrix visual. I have a Scheduling report that has to be displayed in a way that it fits one page for printing purposes (I customized the canvas size first). In the columns I need Day_Name and the date, the rows has Subdep and the Employee Name (sorted according to their job rank, but rank shouln'd be visible).

For each row I need to display Time In, Out, Meal and the Total Hrs. I placed all four fields in the value section. Now I need the grand total for rows and columns only for the Total Hrs. field. Thanks to the previous posts, I am able to hide the totals at the bottom by changing the text and background colors for unwanted fiels. 

I am also hinding the unwanted columns like job rank,  Column subtotals for the field In, Meal and out. The problem occurs when my data gets refereshed and if there is only one employee shcduled for that week. If there are multiple employees, there is no subtotal values and the display doesn't get affected. However column subtotals for in, out and meal have the values in case of one emplyee and because of the text wrap my display gets weird. 

Is there a way to get rid of the column subtotals for these certain columns?

Thank you for any suggestions and for your time.

[KanikaU]

Sample Data

SubDep Date In Out Meal NetHours Employee
Buffet/Smoke 04-19-2024 6a 11a 5 Sim
Buffet/Smoke 04-20-2024 6a 3p 10a-11a 8 Sim
Buffet/Smoke 04-21-2024 6a 3p 10a-11a 8 Sim
Buffet/Smoke 04-22-2024 6a 3p 10a-11a 8 Sim
Buffet/Smoke 04-24-2024 6a 3p 10a-11a 8 Sim
Buffet/Smoke 04-25-2024 6a 3p 10a-11a 8 Sim
Buffet/Smoke 04-22-2024 7a 4p 11a-12p 8 Ole
Buffet/Smoke 04-23-2024 7a 4p 11a-12p 8 Ole
Buffet/Smoke 04-25-2024 7a 4p 11a-12p 8 Ole
Cookhouse 04-19-2024 7a 4p 1p-2p 8 She
Cookhouse 04-22-2024 7a 4p 1p-2p 8 She
Cookhouse 04-23-2024 7a 4p 1p-2p 8 She
Cookhouse 04-24-2024 7a 4p 1p-2p 8 She
Cookhouse 04-25-2024 7a 4p 1p-2p 8 She
Cookhouse 04-20-2024 7a 4p 12p-1p 8 Mic
Cookhouse 04-21-2024 7a 4p 12p-1p 8 Mic
Cookhouse 04-22-2024 10a 7p 2p-3p 8 Mic
Cookhouse 04-24-2024 12p 9p 3p-4p 8 Mic
Cookhouse 04-19-2024 7a 4p 12:30p-1:30p 8 Aiz
Cookhouse 04-22-2024 10a 7p 2p-3p 8 Aiz
Cookhouse 04-24-2024 12p 9p 3p-4p 8 Aiz
Cookhouse 04-20-2024 10a 7p 2p-3p 8 Naz
Cookhouse 04-21-2024 10a 7p 2p-3p 8 Ole

[Greg_Deckler]

@KanikaU The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community