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.
RELATED POSTS
Stay Connected

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

Search

Ready to wrangle your data?