In Excel, I can create a Chart with Program and Commodity shown on one chart in a format that is easier to understand instead of Concatenating like PowerBI does when using drill down.
Here I can click +/- to drill down to Program Level and Commodity level (with Program name in the X-axis also). How can I create similar chart in PowerBI.
Thank you so much!
@lotus22 , Try like. Take program and Community on-axis and sort on them. Use expand drill icon, The reverse square Y icon. Switch off concatenate labels
@lotus22 , Try like. Take program and Community on-axis and sort on them. Use expand drill icon, The reverse square Y icon. Switch off concatenate labels
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
