cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

View solution in original post

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

View solution in original post

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.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 57 members 1,253 guests
Please welcome our newest community members: