drill down on a single label on axis
hey, kan you drill down on a single label on a chart axis? Suppose I have dates on x-axis and I'd like to click on one date to see that days details (new report), is it possible to do so? Obviously, clicking on an other day should trigger same report with
different parameters. thx
February 14th, 2011 8:45am
I don't think you can set an action for an axis label but you can get the axis label or any other applicable field on the data point/series drill-throiugh action.
Paul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com *Please vote if helpful*
Free Windows Admin Tool Kit Click here and download it now
February 14th, 2011 4:21pm
So you mean clicking on the chart instead of the axis label?
That could do
February 15th, 2011 7:14am
Yes. Actions can be applied to a data series (bars, columns, points or slices) or to the chart itself. An action on a data series could pass any field in the dataset at the group level or above it in the group hierarchy. Using an action
for the entire chart won't give you the ability to pass group-level fields.
Play with it and let us know how it works for you.
Paul Turley, MVP [Hitachi Consulting] SQLServerBIBlog.com *Please vote if helpful*
Free Windows Admin Tool Kit Click here and download it now
February 15th, 2011 12:04pm