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
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

Highlighted
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
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.