Drill Down graph is unusable when drilled down

[Matthew]

I have made a bar graph that drills down to graphs with many labels.

A picture of the graph is attached.

 

As you can see, the main categories don't fit when drilled down. Also, the subcategories' labels are too long and there doesn't seem to be a way to make them multiline.

This is really a make or break for us as this graph represents pretty much the whole reason we put together this tool in the first place.

Is there anything we can do to format the graph properly? 

 

As a workaround, is there a way to detect which bar on a graph is clicked and load another report based on the "value" associated with that particular bar?

 

Thanks.

[Matthew]

I have managed to make the graph more presentable by increasing the rotation and changing the layout to landscape. However one problem remains.

 

When drilled down, the main "categories" (the ones along the bottom of the graph with the +/- signs) are squished. In our particular case, we don't need to see the other bars when drilled down. Is there a way to drill down and view only the data in a given "category". For example, using the attached picture, is there a way to click the "+" next to "Plant" and have all of the others ("process, people, etc) disappear until we click on the "-" sign?

 

Thanks.

[Katia]

Hi Matthew,

You can create a  showing the child categories on the chart and use it as a  report that is opened when clicking on the Graph's categories in the main report. 
Check Drillthrough Report Action help article for more detailed information.

When you set a report link on a report item, set a value for the parameter of the target report as well. When the user clicks the link in the summary report, the target detail report opens and displays the information for that specific value.

This approach is demonstrated in the attached report. It can be opened with Standalone Designer R1 2017.

I hope this will help.


Regards,
Katia
Telerik by Progress