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!View all the Fabric Data Days sessions on demand. View schedule
I have created a chart that shows total sales and includes a hierarchy Country, State, City.
I can drill down from Country into State. Is it possible to display the global view (all sales) and drill through to country, state and then city.
Solved! Go to Solution.
HI @Anonymous ,
>> Is it possible to display the global view (all sales) and drill through to country, state and then city.
AFAIK, power bi not support display multiple level summary on data label.
For you requirement. you can consider to create a custom report tooltip to display top level summary.
Create tooltips based on report pages in Power BI Desktop
Regards,
Xiaoxin Sheng
HI @Anonymous ,
>> Is it possible to display the global view (all sales) and drill through to country, state and then city.
AFAIK, power bi not support display multiple level summary on data label.
For you requirement. you can consider to create a custom report tooltip to display top level summary.
Create tooltips based on report pages in Power BI Desktop
Regards,
Xiaoxin Sheng
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!