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...
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 🙂
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.
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.
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.
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
You can't disable click ability in chart. But you can disable interaction between two charts.
Go format tab . Click edit interaction, then select None option in every chart.
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.
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.
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.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!