cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
creynolds Member
Member

Drill through on bar chart

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.

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: Drill through on bar chart

@creynolds,

 


@creynolds wrote:
Hopefully I didn't confuse matters, but I want the selected single bar to have a "Drill-Thru" menu pop up for just that bar. After selecting "Drill-Thru", a table will present the data only on the bar I had selected.

 

Could you show some example?

 

Regards,

Jimmy Tao

7 REPLIES 7
Gokul Member
Member

Re: Drill through on bar chart

did u add legend element into drill through functionalities??? (ie)-on time/scheduled column on ur case22.png

 

 

creynolds Member
Member

Re: Drill through on bar chart

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.

Community Support Team
Community Support Team

Re: Drill through on bar chart

@creynolds,

 

Can't reproduce your issue, based on the test, the tooltip shows single bar value such as name, category and value on my side.

Capture.PNG

 

Regards,

Jimmy Tao

creynolds Member
Member

Re: Drill through on bar chart

Hopefully I didn't confuse matters, but I want the selected single bar to have a "Drill-Thru" menu pop up for just that bar. After selecting "Drill-Thru", a table will present the data only on the bar I had selected.
Gokul Member
Member

Re: Drill through on bar chart

can u pls share pbix file with sample data or share some pics as the whole screen and also drill thru added elements
Highlighted
Community Support Team
Community Support Team

Re: Drill through on bar chart

@creynolds,

 


@creynolds wrote:
Hopefully I didn't confuse matters, but I want the selected single bar to have a "Drill-Thru" menu pop up for just that bar. After selecting "Drill-Thru", a table will present the data only on the bar I had selected.

 

Could you show some example?

 

Regards,

Jimmy Tao

creynolds Member
Member

Re: Drill through on bar chart

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.