Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
dimiz13
Microsoft Employee
Microsoft Employee

PowerBI groups table

I have a table where I have two groups (A and B). There are many group Bs for every group A, and a group B can be in many different Group As. I would like to sort a table by group As such that you can click on or look at a group A and see all group Bs associated with it. Is this possible? When I try to use the table view it just make a one to one mapping of the groups.

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

Looks like just today they added a "Matrix" visualization, this is likely just what you need.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

Looks like just today they added a "Matrix" visualization, this is likely just what you need.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.