Disable drillthrough for few visuals

[vanessa]

Is there a way to disable the drillthrough functionality for a visual on a report which contains the drillthrough column?

[daniel_baciu]

Vote the idea here: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=bd2f4b91-4f04-ec11-b76a-0003ff454902

[bmk]

Is this approach still the only solution since 2018? If yes, this is quite inefficient. There should be a simple straightforward option to disable drill throughs for specific visuals.

[Anonymous]

Hello all, I had the same issue, after I added some tooltips I had the option to Drillthrough - i did not need that so i followed the suggestions here - i changed the name for one of the columns i used in the tooltip. The one specific though whas that i changed the name only for the specific visual - i have no idea if this is a new feature or not but this was a life saver. 

[Anonymous]

I have same issue. Duplicating the column is not working as well as its filtered already. So, I duplicated the table and kept is without a connection to make it work.  For now, this is working for me.

[Anonymous]

@vanessa,

I haven't found any methods that can be used to disable drillthrough functionality for visuals unless you remove the drillthrough column from the visuals.

Regards,
Lydia

[vanessa · Accepted solution]

@Anonymous

I used a workaround. I created a duplicate column and used that in the visual.

[the001]

Great reply and it was so powerful, thanks for the advice!

[josipinho]

Could you please explain this more detailed ?

[vanessa]

@josipinho 

I have a bar graph which is showing the year wise sales. I have enabled drill through on the Year column (i.e. Year column is added to the drillthrough filters field), hence by default this graph will have an option to drill-through.

In order to disable this, I duplicated the Year column (this can be done in the Edit Queries window) in the same table as Year and renamed it to Year_Copy and replaced Year column in the bar graph with this new column.

Since Year column is used in the drillthrough filters field and the bar graph has Year_Copy, the drill-through is disabled.

Hope this was helpful.

[Anonymous]

Hi,

I have tried with this method of you, when i came in drill through option , fact table content is filterd by the the month and how it is possible to discard that fileter in the context when having same field duplicated , in my case that is not working.

[anilreddy128]

I am trying to do the similar thing. Its not working for me as the table is already filtered by the Year Column. How to avoid this.

[josipinho]

Yep I figured it out yesterday after seeing your post 🙂 Thanks for the explanation