March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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.
I've posted an idea about this, please vote:
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=f34e2959-e840-ee11-a81c-000d3a01e6fc
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.
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.
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?
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?
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.
Refer
https://community.powerbi.com/t5/Desktop/How-to-disable-drill-on-feature-in-my-matrix/td-p/543751
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)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
90 | |
86 | |
76 | |
49 |
User | Count |
---|---|
167 | |
149 | |
99 | |
73 | |
57 |