Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
All Courses
  • Free Training Courses
  • AI for Your Role
  • AI & Machine Learning
  • Cloud Tech
  • Data Science
  • DevOps
  • Dashboarding/BI
  • Database
  • WebDevelopment
  • Programming & Coding
  • MS Office & Workplace Productivity
  • QA & Test Automation
  • Professional & Career Development
  • Cyber Security

Courses

  • Computer Fundamentals for Beginners
  • MS Word for Beginners
  • Microsoft Excel for Beginners
  • Microsoft Azure for Beginners
  • AWS Cloud for Beginners
  • Oracle SQL Fundamentals
  • Tableau Fundamentals
  • Power BI Fundamentals
Explore All Programs

Courses

  • AI Essentials
  • AI for Administrative Professionals New Launch
  • AI for Managers & Team Leads
  • AI for Data Analytics & Power BI
  • AI for Software Developers
  • AI for Database & SQL Professionals
  • AI for Project Managers
  • AI for Marketing Professionals
  • AI for Sales Professionals
  • AI for HR Professionals
  • AI for Finance Professionals
  • AI for Customer Support Professionals
  • AI for QA & Test Engineers
  • AI for IT Support & System Admins
  • AI for Cybersecurity Analysts
  • AI for Job Seekers
Explore All Programs

Courses

  • Learn Claude Basics New Launch
  • Learn Claude Advanced New Launch
  • Applied Artificial Intelligence (AI) New Launch
  • AI for Workplace Productivity
  • Azure Fundamentals with AI
  • Advanced Microsoft Azure with AI
  • AI Implications for Business Strategy
  • Mastering ChatGPT & Generative AI Tools
  • Prompt Engineering
  • Agentic AI Solutions
  • AI Product Management
  • AI for Quality Control
Explore All Programs

Courses

  • AZ-900 Azure Fundamentals
  • DP-900 Azure Data Fundamentals
  • DP-100 Data Science on Azure
  • AWS Essentials
  • AWS Cloud Practitioner
  • AWS Solutions Architect
Explore All Programs

Courses

  • DP-100 Data Science on Azure
Explore All Programs

Courses

  • DevOps Essentials
  • DevOps with AWS
  • DevOps with Azure
Explore All Programs

Courses

  • Business Analytics: From Data to Insights New Launch
  • Power BI Advanced
  • Data Analytics with Excel
  • Tableau Beginner
  • Tableau Data Consumer
  • Alteryx & Tableau
  • Tableau Advanced
  • Tableau Certification prep
  • Power BI Beginner
  • Cognos Analytics
Explore All Programs

Courses

  • SQL Server for Beginners
  • SQL for Analysts
  • SQL Server Advanced
  • SQL Server T-SQL Programming
  • SSIS
  • Oracle SQL for Beginners
  • Oracle PL/SQL
  • Oracle SQL Advanced
  • Big Data with Hadoop: HDFS, MapReduce & Ecosystem Tools
  • MS Access
Explore All Programs

Courses

  • Angular Frontend Development
  • Spring 5 Framework
  • Full Stack Web Development
Explore All Programs

Courses

  • Learn Python
  • Python PCEP
  • Python PCAP
  • JavaScript & jQuery
  • Java Certification
  • Python for Data Science
  • Machine Learning with Python
Explore All Programs

Courses

  • Analyzing Data with Excel New Launch
  • Workplace Digital Skills
  • Excel Beginners to Advanced Trending Now
  • Excel for Finance
  • Excel for HR
  • Workplace Computer Skills
Explore All Programs

Courses

  • Selenium QA Automation (Java)
  • Selenium QA Automation (Python)
  • API Testing
  • QA Automation with Python (Advanced)
Explore All Programs

Courses

  • Scrum Master Certification
  • Lean Six Sigma Green Belt Certification
  • Business Analyst
Explore All Programs

Courses

  • Cyber Security Foundations for Beginners
  • Computer Networking for Cybersecurity
  • Windows & Linux Security Administration
  • Ethical Hacking & Penetration Testing
  • Artificial Intelligence (AI) in Cybersecurity
Explore All Programs
  • About Us
    • OCA Skill Sprint Method
    • Meet the Founder
  • Blogs
    • Career Building
    • AI / Machine Learning
    • MS Excel
    • Programming Essentials
    • Database
    • Cloud Computing
    • Tableau
    • Power BI
    • Web Development
    • Tips for Success
    • Qlik
    • Soft Skills
    • Technology
    • Business Intelligence Analyst
    • Message from the CEO
    • DATA ANALYST
  • TechCred
  • Find Your Training
  • Contact Us
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH

 

  • info@ohiocomputeracademy.com
  • +1 866-648-7284
  • Home
  • About Us
  • Blogs
    • Career Building
    • AI / Machine Learning
    • MS Excel
    • Programming Essentials
    • Database
    • Cloud Computing
    • Tableau
    • Power BI
    • Web Development
    • Tips for Success
    • Qlik
    • Soft Skills
    • Technology
    • Business Intelligence Analyst
    • Message from the CEO
    • DATA ANALYST
  • TechCred
  • Find Your Training
  • Contact Us
Find With Us
  • Home
  • Blogs
  • Power BI
  • How to Create Relationships in Power BI

How to Create Relationships in Power BI

Learning how to create relationships in Power BI is a fundamental step in building accurate and efficient data models. Relationships connect tables, allowing data from different sources to work together seamlessly. Whether analysing sales performance, tracking customer behaviour, or linking product information, establishing relationships correctly ensures the reliability of calculations, filters, and visualizations.

This guide explains the importance of relationships in Power BI, the steps to create them, and the options available when managing relationship settings.

New to Power BI? Get hands-on, step-by-step guidance in our Power BI for Beginners course. Start learning now.

What are Relationships Between Tables in Power BI?

Power BI relationships define how data in one table is linked to data in another. For example, a CustomerID field in a Orders table can be connected to the same CustomerID in a Customers table. Once this relationship is in place, visuals and DAX formulas can pull and aggregate data across both tables accurately.

Tip: To create relationships in Power BI, at least one column in each table must contain matching values and use the same data type. These relationships between tables form the foundation of the data model.

When Should Tables Be Linked in Power BI

Creating relationships is essential when:

  • Multiple tables exist in the data model.

  • Reports or calculations need data from more than one table.

  • Tables are part of a normalized (star schema) structure with fact and dimension tables.

Without relationships, Power BI treats each table in isolation, preventing meaningful analysis across related datasets.

How to Create Relationships Between Tables in Power BI

In this section we will see how to create a relationship between Order, OrderDetails and Customer Tables to create a data model.

For this example, we will load OrderDetails, Orders and Customers Tables. The Structure of these tables are shown below:

Table structure of Customers, Orders, and OrderDetails used to create relationships in Power BI data model.

Note: When tables/data is loaded in Power BI, it automatically creates relationships between them based on the matching fields. It is ok to turnoff this feature so that you can create relationships manually. To turnoff this feature, navigate to File and select Options and Settings and then select Options. Under Options, you will see two types of settings: Global and Current File. Navigate to Current File and go to Data Load, uncheck “Autodetect new relationships after data is loaded” as shown in the figure below:

Power BI Options and Settings screen showing how to disable automatic creation of relationships.

Steps:

  1. Load the XLS OrderDetails, Orders and Customers in Power BI desktop. To load data in Power BI, Get Data option or Query Editor can be used. Once the tables are loaded they will appear in the Model view.

  2. To create a relationship between OrderDetails and Orders table, from the ribbon under Home, select Manage relationships.

  3. In the “Manage relationships” box, click on New Relationship. Select the Orders table first and then the OrderDetails table. Make sure that OrderID is selected in both the tables, as this field is used for creating the relationship. Based on the data in the tables, it will display the Cardinality as One to many and Cross-filter direction as Single.

  4. Click on Save

Power BI Manage Relationships dialog showing how to create a new relationship between tables. 

  1. Similarly, create a relationship between Customers and Orders table. Select Customers table first and then the Orders table. Select CustomerID field in both the tables. Based on the data in the tables, it will display the Cardinality as One to many and Cross-filter direction as Single.

The above steps will create a data model as shown in the figure below:

Power BI data model diagram showing relationships between Customers, Orders, and OrderDetails tables.

Best Practice. Always select the lookup table (the table with unique values) first when creating relationships in Power BI. This ensures that Power BI correctly identifies the One-to-Many relationship and maintains the proper filter flow across the data model. Following this approach helps prevent relationship errors and supports a clean, scalable model design.

After creating relationships, it’s equally important to confirm accuracy. Learn more about how to validate data in Power BI

Understanding Cross-Filter direction in Power BI

When creating a relationship between two tables (for example, Orders → OrderDetails), it is necessary to define the cross filter direction, which controls how filters flow between the tables.

Direction

Description

When to Use

Single

Filters flow from one table to the other (typically from the lookup table to the fact table).

Most common for One-to-Many relationships.

Both

Filters flow in both directions between the tables.

Used when fields from both tables need to filter each other, such as in Many-to-Many relationships or complex reporting scenarios.

  • In a One-to-Many relationship (like Orders → OrderDetails), Single direction is usually sufficient and preferred.

  • Bi-Directional (Both) filtering should be used only when necessary, because it increases model complexity and can cause ambiguity in relationships.

Creating relationships in Power BI is essential for connecting data across multiple tables and building accurate reports. By understanding filter direction, and table roles, a strong foundation for reliable data models can be established.

Expand Your Power BI Skills

Interested in mastering Power BI beyond the basics?

Explore the comprehensive guide Mastering Power BI, Second Edition — packed with advanced data modeling, DAX techniques, and real-world reporting strategies.

If you’re looking for hands-on, instructor-led Power BI training, contact us today to learn more about upcoming courses and private training options.

Like
Chandraish Sinha

Chandraish Sinha is the Founder and President of Ohio Computer Academy, a leading institution committed to delivering high-quality IT education. With a passion for teaching and a belief in his company’s mission—Inspire, Educate & Evolve—Chandraish brings over 25 years of experience in the Information Technology industry.

Explore more of his work on his Amazon Author Profile.

0 Comments

Add Your Comment

Post a Comment

Required fields are marked *

✅ Thanks for adding your comment! It will appear after moderation.

0 Comments

Related Blogs
View All Blogs
Power BI Components
Read More
Connect to Excel Data Source in Power BI
Read More
Creating Scatter Chart in Power BI
Read More
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH
Ohio Computer Academy - IT Training & Vocational Education in Dublin, OH

Registered with the Ohio State Board of Career Colleges and Schools — School Registration No. 2395

About Us
  • Contact Us
  • Our Story
  • Training Gallery
  • Reviews
  • Books
  • Greater Columbus Training Center
Trainings/Services
  • Course Categories
  • Learning Paths
  • Frequently Asked Questions
  • AI Advantage
Contact Us
  • Phone:+1 866-648-7284
  • E-mail: info@ohiocomputeracademy.com
  • Address:

    Dublin, Ohio
    5900 Sawmill Road, Suite # 150, Dublin, OHIO 43017 USA

Thank you
Failed
Free Training Courses
  • Computer Fundamentals for Beginners
  • MS Word for Beginners
  • Microsoft Excel for Beginners
AI Courses
  • Claude Basics
  • Claude Advanced
  • AI for Workplace Productivity
  • Prompt Engineering
  • Agentic AI Solutions
  • AI for Quality Control
Cloud Tech
  • DP-900 Azure Data Fundamentals
  • DP-100 Data Science on Azure
  • AWS Technical Essentials
  • AWS Cloud Practitioner
  • AWS Solutions Architect
DevOps
  • DevOps Essentials
  • DevOps with AWS
  • DevOps with Azure
Dashboarding/BI
  • Tableau Beginner
  • Power BI Beginner
  • Data Analytics with Excel
Database
  • Oracle SQL for Beginners
  • SQL for Analysts
  • SQL Server for Beginners
MS Office & Workplace Productivity
  • Workplace Digital Skills
  • Excel for Finance
  • Excel for HR
  • Excel Beginners to Advanced
  • Workplace Computer Skills
Learning Hub
  • Begin Your IT Career
  • Generative AI & Workplace Productivity Foundations
  • Claude AI Learning Path
  • Data Visualization Foundations
  • Data Analytics Career Path
  • AI for Business & Data Applications
  • Programming Foundations & Development Path

© 2026 Ohio Computer Academy. All rights reserved.

  • Privacy
  • Terms & Conditions