cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dimiz13
Microsoft
Microsoft

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.


@ 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!:
Mastering Power BI 2nd Edition

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.


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors