How do I remove Grand total and keep subtotals?

[Regnbagar1]

Hi,

I'm having problem to remove grand total and keep subtotals in the latest verion of Power BI desktop. I don't find the suitable options under Grand total.

For Grand total there isn't any on and off option. Does anyone else have the same problem?

[truptis · Accepted solution]

Hi @Regnbagar1 ,
There is a sticky tape solution to this. We can't actually hide the total rows but we can change it's fonts to white. 
Please refer this solution:

considering it is a matrix/table visual, select the visual, then we can go to the Format option, Field Formating:

in Field formatting, click on drop down(as shown in the image) and select the column for whose value u need to change)

after selecting the column, change the Font color of the text to White:

By this way, the values won't be seen/hidden.

If this post helps you, then please consider this and accept it as a solution to help other members find it faster. Also, hit a thumbs up if it solves your query. 
Regards,
TruptiS

[Regnbagar1]

I solved it by using "Apply to labels" under Grand total. Thank you so much for the help!

[Regnbagar1]

It dosen't look the same for me since I updated Power BI desktop. I don't have that option anyomore.

[Regnbagar1]

Hi,

Thank you for the help. It worked to make the values white. Is there any way you can make the column header white aswell? 

[truptis · Accepted solution]

Hi @Regnbagar1 - Glad to know it worked. 
For column headers, under the same field formatting, you will see Apply to header option. Click on that.

@Regnbagar1 -> Since it is working for you, request you to please mark this as a solution. Thank you. 

Regards,
TruptiS

[truptis · Accepted solution]

Hi @Regnbagar1 ,
There is a sticky tape solution to this. We can't actually hide the total rows but we can change it's fonts to white. 
Please refer this solution:

considering it is a matrix/table visual, select the visual, then we can go to the Format option, Field Formating:

in Field formatting, click on drop down(as shown in the image) and select the column for whose value u need to change)

after selecting the column, change the Font color of the text to White:

By this way, the values won't be seen/hidden.

If this post helps you, then please consider this and accept it as a solution to help other members find it faster. Also, hit a thumbs up if it solves your query. 
Regards,
TruptiS