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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I want to take a column that has multiple pieces of text data, (ie: in progress, completed, not started, etc.) and summarize each one of those into it's own column (so each separate data point in the original column gets summarized in its own column). I am wanting to try to do this summarization with a grouping of another column. (ie: Group by Manager Name, summarize by each 'status' I have listed in that particular column).
This can be done in a separate table if need be.
@jmason8 , You can simply do that in a visual. Add whatever column you want and then add measures (one with Aggregation ) in table or matrix visual
You can consider summarize in DAX and group by power query , if you want a new table
https://docs.microsoft.com/en-us/power-query/group-by
https://www.sqlbi.com/articles/all-the-secrets-of-summarize/
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.