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.
Hi - I've got 2 tables (one with years and a total and one with countries breaking down that total)
I want to click on the total year bar chart and then display the country values for that year.
I've tried drill through but don't get the drillthrough option when I right click...please help!
Cheers TC
Solved! Go to Solution.
I was making it too complicatd by having another table with totals when the countries table sum the values!
Getting there thanks
@Anonymous have you create a hierarchy? not sure you can do that if they in separate tables, you need to tell it what to drill through to
layer the yearon top then drag the country under that in your field / column section
Proud to be a Super User!
I've tried a really simple set of data and can switch between countries Ok but can't go from the pie chart to the detailed bar chart...right click doesn't show the drill through option like in the tutorial. (I've got a latest version of software) - what am I missing here please?
@Anonymous i dont think im getting what you trying to do. you want to drill down to the country in which object? if you dont put the country in the object field you can't drill down to it, from what i can see you only have the year, and min of the value. You need to drag the country under the year
Proud to be a Super User!
I want to click on a pie section and go to the detail - the right click doesn't show the drill through option. Is there a setting that is not turned on?
@Anonymous did you drag the country into your visual as i stated?
Proud to be a Super User!
I was making it too complicatd by having another table with totals when the countries table sum the values!
Getting there 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 |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |