Uploaded May 2025 | Updated November 2026, 3 hours ago
Set up more than one relationship between tables in Power BI Data Model. Learn how to work with USERELATIONSHIP() function in DAX to manage active vs. inactive relationships between tables.
Also learn how to visualize data from both tables in matrix and "new" card visuals with powerful story-telling tricks.
π₯ Sample file (demo): app.powerbi.com/view?r=eyJrIjoiODY2N2RiYzUtZjYzNy00OTVmLTgxZDctNjQ0NTA5ZDQxYWYyIiwidCI6IjUzNTA4ZDUyLWQxYjAtNDliMC1iNGJhLTM1MzNjMTI0OWEwMSJ9
π Raw data: github.com/chandoo-org/Power-BI/blob/bc089ea4514d84221fd174a564fd7156177dbc43/insurance_dashboard/motor_data14-2018.zip
πComplete workbook: Available in my online Power BI class
π§βπ» Join my Power BI Class (get $100 / $50 discount): Visit chandoo.org/wp/power-bi-course to sign up for my complete, step-by-step Power BI course. Use coupon code SAVE100 to get $100 or Rs 6,000 discount on the course fees.
π Video timestamps:
0:00 - More than one relationship between tables (how they look)
0:45 - About the dataset (insurance policy data)
3:10 - The relationships between tables - active vs. inactive
4:03 - Creating DAX measures to analyze data
5:52 - USERELATIONSHIP DAX function
8:58 - Matrix visual with net policy gain trends
13:45 - You are going to LOVE π this
14:48 - "NEW" Card Visuals and showing Individual Year Values
18:55 - Reference Labels & Conditional Formatting
21:10 - Dynamic Card Titles
22:30 - Formatting the cards
24:28 - Custom interactions
~
#powerbi #datavisualization #dashboards
Set up more than one relationship between tables in Power BI Data Model. Learn how to work with USERELATIONSHIP() function in DAX to manage active vs. inactive relationships between tables.
Also learn how to visualize data from both tables in matrix and "new" card visuals with powerful story-telling tricks.
π₯ Sample file (demo): app.powerbi.com/view?r=eyJrIjoiODY2N2RiYzUtZjYzNy00OTVmLTgxZDctNjQ0NTA5ZDQxYWYyIiwidCI6IjUzNTA4ZDUyLWQxYjAtNDliMC1iNGJhLTM1MzNjMTI0OWEwMSJ9
π Raw data: github.com/chandoo-org/Power-BI/blob/bc089ea4514d84221fd174a564fd7156177dbc43/insurance_dashboard/motor_data14-2018.zip
πComplete workbook: Available in my online Power BI class
π§βπ» Join my Power BI Class (get $100 / $50 discount): Visit chandoo.org/wp/power-bi-course to sign up for my complete, step-by-step Power BI course. Use coupon code SAVE100 to get $100 or Rs 6,000 discount on the course fees.
π Video timestamps:
0:00 - More than one relationship between tables (how they look)
0:45 - About the dataset (insurance policy data)
3:10 - The relationships between tables - active vs. inactive
4:03 - Creating DAX measures to analyze data
5:52 - USERELATIONSHIP DAX function
8:58 - Matrix visual with net policy gain trends
13:45 - You are going to LOVE π this
14:48 - "NEW" Card Visuals and showing Individual Year Values
18:55 - Reference Labels & Conditional Formatting
21:10 - Dynamic Card Titles
22:30 - Formatting the cards
24:28 - Custom interactions
~
#powerbi #datavisualization #dashboards










