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.
Hi,
I am currently trying to achieve a certain type of visual in Power BI and am really struggling. Basically I want to be aqble to break down a set of data by a certain factor but I would like it to look like the grouped rows function in Excel. Here is a SS of what I am trying to get.
@Anonymous Closest thing is probably a Matrix visual with a row hierarchy.

How does one do this?
but I would like it to look like the grouped rows function in Excel.
Power BI is not Excel. If you need it to look like this, keep using Excel.
Hello @Anonymous
You can try Matrix table for this visual but this depends on how structured you data is to support this visual because Power BI works in tables concept whereas in excel it is cells..
If you find this helpful , please mark it as solution and Your Kudos/Likes are much appreciated!
Thank You
Dharmendar S
Check out the November 2025 Fabric 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!