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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Disable total of text column in Grand Total.

Hi Experts,

 

I have a scenario where the text column of matrix is calculating/showing the text in the Grand Total row. I have requirement to completely disable/hide the text from the Grand as well as subtotal. Can we achive this? 

Visualization used: Matrix


The forum dicussed in below link is not actaully fullfiling my requirement.
https://community.powerbi.com/t5/Desktop/Disable-Subtotal-for-Text-Column-Matrix/m-p/477611#M222203

 

Below snippet of the text subtotal (red stricked) is calculated/showed which need to be removed. Visualization used

shreesom_0-1593093889703.png

 

Thanks in advance. 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi,

 

Thanks for various solutions. But I found a direct option to do this.

In the matrix visualization format -> Feild formatting -> select the feild you want to hide the total and change the color of the font as same as background. Make sure to toggle ON the "Apply to total" in same Feild formatting section. The text/value will get blend into the background, thus hiding it from user.

 

Thanks

SS

View solution in original post

10 REPLIES 10
liyunzhen001
New Member

liyunzhen001_0-1727763709772.png

The easiest way is to insert a shape matching the color of the table to block the text.

o_belov
Advocate II
Advocate II

Name_meas = IF ( SELECTEDVALUE (Table [your_first_column_for_ex_ID] ) <> BLANK(), SELECTEDVALUE (Table [Column_that_need_to_see]) , BLANK() )

Loved this solution..pretty smart. Thansk for sharing. 

thanks so much! the problem with the other solution is that you can't change the color of the whole column and hide the grand total. Definitely putting your solution in my ever growing BI measure book.

Anonymous
Not applicable

Hi,

 

Thanks for various solutions. But I found a direct option to do this.

In the matrix visualization format -> Feild formatting -> select the feild you want to hide the total and change the color of the font as same as background. Make sure to toggle ON the "Apply to total" in same Feild formatting section. The text/value will get blend into the background, thus hiding it from user.

 

Thanks

SS

What I think you should do and that works for me is this.

- Select the matrix table,

- go to format and under the visual setting,

- select specific columns

- select the column you want to hide from the drop down

- enable Apply to total

- Change the color to the background color and you will be fine.

tosinrefined_0-1688656493423.png 

tosinrefined_1-1688656563619.png

 

 

Please if it works for you click thumbs up. Thank you.

v-xuding-msft
Community Support
Community Support

Hi @Anonymous ,

 

The answer of parry2k should work perfectly. If it is helpful, please accept it as solution. If it can't work for you, please add a rectangle to have a try.

2.gif

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-xuding-msft this is an excellent and clever solution!

FrankAT
Community Champion
Community Champion

Hi @Anonymous,

use the format options for the subtotals:

 

25-06-_2020_16-51-02.jpg

Regards FrankAT

parry2k
Super User
Super User

@Anonymous I guess these text columns are using aggregation like first or last value, you need to create a measure for each column and then use HASONEVALUE function on the column you have put on rows

Text Measure = 
IF ( HASONEVALUE ( Table[Columnonrow] ), MAX ( Table[TextColumn] ) )

 

I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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