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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics