Hello,
I have the bellow dataset, and i want to display it in a chart sort by "Dept" in row and "Level" in column but i want a specific column by "Dept" with my causes of all levels.
Currently i succeed to sort by "Dept" and "Level" but my "Causes" column only show the level 2 causes.
Did you now a way to aggregate the row of my dataset to display it in my chart ?
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.
