Drill through on bar chart

[Anonymous]

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.

[Surender_265]

Hi 

I am stucked in same situation, if you have resolved your issue please help me.

How to apply drill through based on single value.

Thanks

Surender

[Gokul]

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

[Anonymous]

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.

[v-yuta-msft]

@Anonymous,

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

Regards,

Jimmy Tao

[Anonymous]

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.

[v-yuta-msft · Accepted solution]

@Anonymous,

---

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

[Anonymous]

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.

[Gokul]

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