Here’s how to turn off all interactions in Power BI [QUICK GUIDE]

Milan Stanojevic
by Milan Stanojevic
Deputy Editor
Loading Comments
Download PDF
Affiliate Disclosure

There’s no denying that Power BI offers a lot of features. Still, many users need even more functions.

For example, people want to disable all interactions in Power BI. Therefore, other users shouldn’t be able to click, modify or interact in any way with the graphs from a report.

One user said the following on the official forum:

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?

So, the user can somehow control the interaction, but only partially. The OP wants the end-users to not be able to click on the graph at all.

Unfortunately, Power BI doesn’t have this option. You can’t disable the ability to click on a chart, but you can disable the interaction between two charts.

Steps to disable interactions in Power BI

1. Turn off interactions in Power BI Desktop

  1. Go to the Format tab.
  2. Select Edit interactions.power bi edit interactions
  3. Select the None option in every chart.

2. Turn off interactions in Power BI Service

  1. Go to Edit Report.
  2. Click on Visual interaction.
  3. Select None option in every chart.

These workarounds will disable the interaction between two charts. So, if another user clicks a chart, it will not affect the rest of the charts on the page.


Epic guide alert! Everything there is to know about Power BI is right here!


3. Use Drillthrough in Power BI Desktop

  1. Select your chart.
  2. Go to the Data/Drill option on the ribbon.
  3. Click on Drillthrough.power bi drillthrough

It is worth mentioning that forcing the chart to use the Drillthrough option will disable any marking.

Conclusion

Keep in mind that these are only workarounds. So, probably they will not work for everyone.

Power BI doesn’t have the option to completely disable any interaction with the charts. Simply put, the end-user can’t just look at these charts as if they were images.

Did you find our workarounds useful? How do you disable interactions in Power BI? Let us know in the comments section below!

RELATED STORIES YOU NEED TO CHECK OUT: