Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi,
I was wondering if we can have drill through a line chart.
Suppose, I have a trend of population of a country through the years with population count in Y axis and years on X.
Is it possile to have a drill throughover this chart, where in drill page, I get population trend based on states.
I cannot use drill down for this because I want to make chart of say 10 countries and in drill through, I want to show trend of top ten states of that particular country through which I drilled through.
Thank you in advance.
Solved! Go to Solution.
Hi @Anonymous ,
Based on my test, you could use the drillthrough function.
Sample file:
Create below picture in Page 1:
Create below picture in page 2 and set the drillthrough value:
You could also download the pbix file to have a view.
Regards,
Daniel He
Hi @Anonymous ,
Based on my test, you could use the drillthrough function.
Sample file:
Create below picture in Page 1:
Create below picture in page 2 and set the drillthrough value:
You could also download the pbix file to have a view.
Regards,
Daniel He
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 46 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 47 |