I have a bar chart which I want to drill-through on each "single" bar. What's happening, when I select a single bar, it highlights two bars since there are two bars for each City name shown on the axis. How can I drill-through on only one of the city bar's and show only the details for that one single bar? Example, if I click on Austin Work Orders Behind Schedule, it displays the result for both Behind Schedule and On Time.
Solved! Go to Solution.
I added both Behind Schedule and On Time to the Filtered Section on the chart I want to view their specific data. I still am getting the combined view of both Behind Schedule and On Time.
I have a work around for now. It's somewhat complicated that I am using a summary table and detailed table as the Drill-through. I believe the information I was trying to display was not as straight forward as clicking on one bar to drill through to see only that bar's information. Instead, the drill-through leads to a summary table, which also displays a 2nd table thath holds more detail. For now, I will close down this ticket. Thanks.