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
Anonymous
Not applicable

Disabling chart highlighting and interactions

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?

19 REPLIES 19
Anonymous
Not applicable

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. 

Anonymous
Not applicable

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.

FXFelix
Helper II
Helper II

Hello,

 

Thanks @marcoselias for the tip 🙂

marcoselias
Advocate V
Advocate V

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.

@marcoselias 

 

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

Anonymous
Not applicable

You can vote for this feature here

I have voted for this idea. Thanks!

 

Anonymous
Not applicable

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 :(.

Gnanasekar
Helper III
Helper III

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

Anonymous
Not applicable

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.

 Screen Shot 2020-05-18 at 10.46.10 AM.png

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!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

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.