An Introduction to Grouping Tables in Power BI: A Bridge Table Too Far

Grouping tables in Power BI is a powerful modeling technique that allows you to select from overlapping groups either in a slicer or across a matrix. Useful for scenarios where say, you have several ad campaigns going on and an individual product can be a part or more than one campaign. Traditional calculated columns or Snowflake tables produce ugly and unpleasant user experiences while grouping tables give end users exactly the behavior they were hoping for. In this video Brian Grant will walk you through what they are and how you can build your own. Since these do usually utilize bi-directional relationships he will also walk you through some things to watch out for when adding these.

Download the companion files here.

Brian Grant

Brian Grant

Brian Grant is a masterful Senior Analytics Consultant by day, and a Power BI legend by night. A passion for Power BI drove him to holistically master the tool from all three perspectives: M, DAX, and the visualization layer. Brian is a constant teacher who leads Power BI training sessions, while sharing his wealth of expertise through video and blogging resources.
SHARE THIS
Share on twitter
Share on facebook
Share on linkedin
Share on email
RELATED POSTS

Subscribe

Subscribe to CSG. We’ll supply your inbox with the latest blog posts, training videos, and upcoming events.

Ready to wrangle your data?