Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hi Everyone,
In a report which i am working on, I want to disable the click on a particular chart. (The issue is not about edit interactions).
I know it is not possible in power bi . but is there a workaround ? Please see below for detailed issue
I have two charts in power bi . The first chart filters the second one , so i changed edit interactions to filter in second one. And I dont want second chart to interact with the first chart . So i changes edit interactions to none in first chart. But the issue is , if i click on the second chart , there is no change in first chart which is ok . but the result is getting distutbed in second chart . Please view below pictures
i clicked on a file id and changes happen in seond chart. but when i click on the second chart, the result gets distirbed like below picture.
Is there any way to keep the result undisturbed until i click on the next file ID.
Appreciate If anyone could suggest me a workaround. Thanks in Advance
Solved! Go to Solution.
hi @Anonymous - I do not think there is a feature at the moment to disable the click as you require - you could use the approach to put a blank text box but unfortunately that would disable your tool tip as well.
Please mark the above comment as a solution to help others find it more quickly. Also please provide a 👍 if my comment helped with solving your issue. Thanks!
Proud to be a Super User!
This is a workaround, but it will disable the filtering from clicking a viaual for more than just the one visual:
Hi, @Anonymous , did u try this functionality on UI to keep vizs from filtering each other?
Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! |
DAX is simple, but NOT EASY! |
Hi @CNENFRNL ,
The Issue here is not about edit interactions. Edit intearctions are working as expected and is not effecting first visual even if i click on the second chart,but the second chart result is getting changed and i want it to be unchanged until i click another file id - in first chart.
See above pictures. I want hover option only in the second chart . But i thought if the end user click by mistake it can mess up . So I am looking for a workaround
hi @Anonymous - you can place an empty text box over the 2nd visual with the exact dimensions - this way the visual will be visible to the user but when they click they will not be able to click or interact with the visual as such.
Please mark the above comment as a solution to help others find it more quickly. Also please provide a 👍 if my comment helped with solving your issue. Thanks!
Proud to be a Super User!
Thank you for your quick responses. I tried it But The visual have tooltip , as i hover on it it shows important information. that is not working with the method Suggested ..
the original dashboard is like below. End user will be clicking on each file id to see changes in second chart and only hover on the second chart to see extra information provided in tooltip report. This is the functionality of the report. But the clicking on second chart is messing up the result which is the problem
Hi @Anonymous ,
Based on your description, I think the problem may be in toolip.
You could use isfiltered in a measure or tooltip page.
See if this blog will help you.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @V-lianl-msft ,
Tooltip is working fine . its not the problem .
Conventionally we use a button in the home page to drill through to another page . In that case the result in the drill through page remains same until we click back button and select another file id to activate drill through..
But here i kept the charts in same page. Here the problem is the result in the second chart are disturbed before clicking on the next file ID . When i click on a file id in first chart ,it filters the second chart .This is fine. but What is the problem is ,in the second chart the end users may click by mistake instead of hovering, and clicking on second chart means the result is messed up . So i want to disable the click and enable only hovering on second chart.
hi @Anonymous - I do not think there is a feature at the moment to disable the click as you require - you could use the approach to put a blank text box but unfortunately that would disable your tool tip as well.
Please mark the above comment as a solution to help others find it more quickly. Also please provide a 👍 if my comment helped with solving your issue. Thanks!
Proud to be a Super User!
I'm having the same issue.
I filter from a 1st graph and when a point is selected on the 2nd, the filter is broken. I still want to see the tooltip so can not use a transparent object to stop the user clicking on the second graph.
User | Count |
---|---|
94 | |
92 | |
85 | |
83 | |
49 |
User | Count |
---|---|
150 | |
142 | |
112 | |
73 | |
55 |