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
dedelman_clng
Community Champion
Community Champion

Disable tooltip on matrix subtotals and/or blank rows

I have a simple matrix visual that is showing a two-tiered hierarchy with a single metric

Data:

AREA NAMEEQUIPMENTMETRICEXTRA INFO
Area 1Eq 11abc
Area 1Eq 22def
Area 2Eq 33ghi
Area 2Eq 44jkl
Area 2Eq 55mno
Area 3Eq 66pqr

 

Visual

matrix.png

 

I have set the row subtotals on EQUIPMENT to be white font on white background so there is a space between each Area (note: I have tried to do what I am about to ask with row subtotals off and "Blank Rows" on, but get the same results)

 

I have a tooltip page that displays extra information about the particular piece of equipment in a hover-over. I can control the information displayed on tooltip when hovering over a subtotal by using HASONEVALUE(), but I would rather have the tool tip  completely suppressed so it doesn't look like there's missing data.

 

Single Row:

matrix 2.png

 

Subtotal/blank row

matrix 3.png

 

Is there a way to disable the tooltip on subtotals and/or blank rows in a Matrix visual?

 

Thanks,

David

 

 

 

2 ACCEPTED SOLUTIONS
parry2k
Super User
Super User

@dedelman_clng unfortunately you cannot dynamically control the visibility of the tooltip. Maybe put this as an idea on the ideas forum if doesn't exist already.

 

 



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.

View solution in original post

Ritaf1983
Super User
Super User

Hi @dedelman_clng 
No, unfortunately, the tooltip will show up in every row of the matrix including totals & subtotals.
The maximum you can do is workarounds with the object on the tooltip that will be white when hovering on the unwanted rows + some message to the user. 
Something like :

Ritaf1983_0-1726852167017.pngRitaf1983_1-1726852204507.png

if this can help I  attached a pbix, you can follow my steps.

If my answer was helpful please give me a Kudos and accept as a Solution.



Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

2 REPLIES 2
Ritaf1983
Super User
Super User

Hi @dedelman_clng 
No, unfortunately, the tooltip will show up in every row of the matrix including totals & subtotals.
The maximum you can do is workarounds with the object on the tooltip that will be white when hovering on the unwanted rows + some message to the user. 
Something like :

Ritaf1983_0-1726852167017.pngRitaf1983_1-1726852204507.png

if this can help I  attached a pbix, you can follow my steps.

If my answer was helpful please give me a Kudos and accept as a Solution.



Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
parry2k
Super User
Super User

@dedelman_clng unfortunately you cannot dynamically control the visibility of the tooltip. Maybe put this as an idea on the ideas forum if doesn't exist already.

 

 



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
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!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

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.