Forum Discussion
Disable drillthrough for few visuals
Anonymous
I used a workaround. I created a duplicate column and used that in the visual.
Anonymous
I used a workaround. I created a duplicate column and used that in the visual.
Could you please explain this more detailed ?
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
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.
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.
