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 wonderi...
General Comment
Need Help
Tips and Tricks
marcoselias's avatar
marcoselias
Advocate V
8 years ago

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
    8 years ago

    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
      8 years ago

      You can vote for this feature here

      • sindhujaa's avatar
        sindhujaa
        Frequent Visitor
        8 years ago

        I have voted for this idea. Thanks!

         

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      2 years ago

      I did it from the Power BI service and it worked without a problem

  • FXFelix's avatar
    FXFelix
    Resolver I
    6 years ago

    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
      5 years ago

      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
      6 years ago

      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's avatar
      marcoselias
      Advocate V
      6 years ago

      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.

  • gco's avatar
    gco
    Resolver II
    7 years ago

    marcoselias 

     

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