Forum Discussion
Disable drillthrough for few visuals
Anonymous
I used a workaround. I created a duplicate column and used that in the visual.
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.
Yep I figured it out yesterday after seeing your post :) Thanks for the explanation