Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

  • 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 :)

    • sindhujaa's avatar
      sindhujaa
      Frequent Visitor

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable

        You can vote for this feature here

    • FXFelix's avatar
      FXFelix
      Resolver I

      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 ?

       

       

      • marcoselias's avatar
        marcoselias
        Advocate V

        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.

    • gco's avatar
      gco
      Resolver II

      marcoselias 

       

      Your solution of drawing a rectangle around the visual worked perfectly for me.  Thanks for your suggestion.

  • Anonymous's avatar
    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

    • marcoselias's avatar
      marcoselias
      Advocate V

      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

    • Anonymous's avatar
      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

      • JaileneW's avatar
        JaileneW
        Frequent Visitor

        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.

         

  • Anonymous's avatar
    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...

    • Markzolotoy's avatar
      Markzolotoy
      Impactful Individual

      Same here. It's just crazy to use workarounds for problems like this.

  • Anonymous's avatar
    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.