Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
did u add legend element into drill through functionalities??? (ie)-on time/scheduled column on ur case
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.
@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,
@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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |