I have a bar chart that shows a count (y-axis) by Category Type (series) and Month/Year (x-axis). The chart is filtered by Location. I am trying to pass the parameters Category Type, Month/Year, AND Location to a drill-thru report upon clicking a specific bar. Since Location is only a filter and is not actually displayed in my chart, it will not pass.
Note: I am actually using this chart in Business Insight so it is not as simple as passing Location as a parameter instead of a data item.
You will need to bring Location in as an item in your chart query in order to be able to pass it as a data item. I imagine you already have it in a _BusinessInsight_ query if you are filtering on it within Business Insight?
Regards,
MF.
I figured out the issue. I did have Location in my query but because it was not actually in the chart object, it would not pass. I had to click on the Series value within the chart and in the Properties pane on the left side I clicked Data -> Properties. I then checked the box for the attribute I wanted to include in the chart (Location).
Thanks!