I'm trying to visualize tourism data with age categories in the last few years. With the data I have, I couldn't get a proper chart in power bi. But it worked in excel. Can someone help me with this? (age category data showed in percentages)
@Anonymous It is a 100% stacked column chart. Put the year in X-axis and the Other category column ain Y-axis. Aggregation as a sum.
Below image for your reference. Hope it helps you to achieve the desired output.
@Anonymous It is a 100% stacked column chart. Put the year in X-axis and the Other category column ain Y-axis. Aggregation as a sum.
Below image for your reference. Hope it helps you to achieve the desired output.
Helpful resources
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Power BI Monthly Update - October 2025
Check out the October 2025 Power BI update to learn about new features.
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.
