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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
ccyangdi
Microsoft Employee
Microsoft Employee

How to make a matrix not clickable?

I have a matrix in powerbi desktop, which the user doesn't want it to be clickable.

1. I have already turn off the interaction with other visuals.

2. I have tried to cover the matrix with a transparant card. However, since our matrix has scroll bar, either I cover the scroll bar so the scroll bar is not work, or I left the scroll bar outside the card, then after the user click on scroll bar, the matrix is clickable again.

 

Anyone has better solution for this ask?

 

Thanks in advance.

9 REPLIES 9
Petja
Advocate II
Advocate II

bannerhealth
New Member

Do we any solution for this? We are facing the same issue as this and we would want to use the scroll bar without making any selection.

jessegorter
Helper I
Helper I

I honestly think the transparent box over a visual is a trick best avoided. It does work, but like you said, if you have scrollbars you already run into problems. Is it absolutely vital that a matrix is unclickable?

I know, not a solution, but the more experience I get the more I get the opinion that these kind of workarounds create more problems than solutions.

armely
Helper I
Helper I

If you put a text box over it they won't be able to click.
ccyangdi
Microsoft Employee
Microsoft Employee

As I mentioned in the original post, I have tried to cover the matrix with a transparant card. However, since our matrix has scroll bar, either I cover the scroll bar so the scroll bar is not working, or I left the scroll bar outside the card, then after the user click on scroll bar, the matrix is clickable again.

 

Could you help to solve this issue?

@ccyangdi 

Apologies upfront since I have not come up with a solution (I did think that placing the card/text box in front of the matrix would screen the matrix visual once published to the Power Bi service but it doesn't...)

Out of curiosity, if you have disabled interactions, is this just a cosmetic issue? 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






The client says it is misleading when the detail table highlights some rows, so they want to disable this effect.

amitchandak
Super User
Super User

Refer

https://community.powerbi.com/t5/Desktop/How-to-disable-drill-on-feature-in-my-matrix/td-p/543751

https://community.powerbi.com/t5/Desktop/Matrix-Preview-Disable-Drill-Down-when-using-several-fields...

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Add screenshots below to make my question more clear.

We want the lower matrix always show as screenshot below and never as in the next screenshot (some rows are highlighted)

a1.JPG

 

 

a2.JPG

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.