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 moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I've created several graphs within one report. When clicking on certain elements of a graph, I can control the interaction that this selection has on other graphs within the report, but I was wondering if there is the ability to completely disable the clickability of a graph? I don't want the end users to be able to click on the graph at all, so neither the selected graph or other graphs would be highlighted?
However the query is a bit old, but the solution is now too easy to achieve.
Just plot a Transparent Shape on the Chart/s or on the page. Widgets will automatically be disabled by users.
The original question is over three years old, but I'd still love to hear a definitive answer if anyone knows out! I'd also like to disable the clickability of some stacked bar charts I've built...
Same here. It's just crazy to use workarounds for problems like this.
What I ended up doing was to put a rectangle on top of my visual; background off and line transparency 100%. Then, I made sure it was on the front (Format > Bring forward > Bring to Front).
In case it makes a difference, my report has the visual options set to "Hide the visual header in reading vew" (under File>Options and settings>Report settings).
Hope that helps, although your post is from last year 🙂
Hello @marcoselias,
Good idea the rectangle, but if you want to keep the headers clickable (in order to sort data), the table come to the front and become selectable 😯
Did you find a workaround ?
I believe the workaround has come out with the September 2020 version to maintain layer order. This way, you can keep the invisible rectangle coverring the visual to prevent any interaction with it, but leaving the header clickable.
@FXFelix , you are right, I noticed that too and that's why I decided to have the invisible rectangle be the same size as the entire visual to avoid the visual "coming to the front". Have not found a workaround yet, sorry.
@FXFelix ,
I did not allow clicking on the table that is why the invisible box worked for me. And i have not seen any workarounds anywhere. Sorry.
Your solution of drawing a rectangle around the visual worked perfectly for me. Thanks for your suggestion.
I am facing the same problem as well , the drillthrough turns off every time after refresh in the Power BI service , though this idea works in the Power BI desktop.
The problem is using the rectangle as suggested , is we will not be able to view the datapoints in the graph by hovering over the charts.
Is there a way to retain drillthrough ON in Power BI service as well.
Thanks in advance.
I did it from the Power BI service and it worked without a problem
I have voted for this idea. Thanks!
One thing you can do is select your chart, go to Data/Drill option on the ribbon and click on Drillthrough.
This will force the chart to use drillthrough but since you havent configuered any column to do that it will disable any marking
This is a good suggestion. However, while it seemed to work in Power BI Desktop, it didn't in the Service :(.
Hi @Anonymous
You can't disable click ability in chart. But you can disable interaction between two charts.
In desktop,
Go format tab . Click edit interaction, then select None option in every chart.
In Service
Go edit report. Click visual interaction, then select None option in every chart.
It will disable interaction between two charts. If end user click a chart, it wont affect remaining chart in page.
By
Gnanasekar
Hi @Gnanasekar,
Thanks for the reply. It's more the fact I want to disable the clickability of each individual graph. I'll have to live with the fact users can click on each graphs.
Thanks,
Steven
Currently we can disable this feature to disable all interactions. However may need to be careful about using this if you would like to have some visuals interact with each other.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |