How to Create and Manage Relationships in Power BI | Microsoft Power BI for Beginners

In this series we will be walking through the basics of Microsoft Power BI. In this video we will be walking through how to manage relationships in Power BI.

Favorite Power BI Courses:

____________________________________________

SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________

RESOURCES:

Coursera Courses:

Udemy Courses:

*Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!*
____________________________________________

SUPPORT MY CHANNEL - PATREON/MERCH

____________________________________________

Websites:
📱Instagram: @Alex_The_Analyst
____________________________________________

0:00 Intro
0:30 Taking a look at the Data
1:29 Loading Data into Power BI
2:02 Auto-Generated Relationships
3:45 Cardinality
4:32 Cross Filter Direction
6:28 Making Relationship Active
6:58 Building Relationships from Scratch
7:58 Outro

*All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for*

[cococnk]

Going over, your Power BI tutorials for beginners, I love them

[James-nurq]

The Model Tutorial file was renamed to Bins Lists Tutorial, if anyone is curious

[babajara]

Thanks Alex, for making so easy and straight to the point.

[YoussefTsun]

I didn't understand where to use single relation, I felt that I have always to make it both
Thank Mr.

[infinity]

You explained so well cardinality and many to one. Thank you !

[FaiLhappy]

Hi Alex, I'm enjoying your Power BI series, thanks for making these videos. They came just at the right time for me as my boss wants me to create her a Power BI dashboard to analyse job application statistics and I've never done it before. These videos will be a great starting point. Thanks again!

[apaladas]

Hi Alex! Loved the last 3 videos. They are really helpful id someone is a complete newbie in Power BI. Eagerly waiting for the whole playlist so that I can Binge-learn ;)

[adampol]

Hi Alex :) I really like Your videos, but in that paricular one I wouldn't recommend using both direction in relationships, especially for beginers. It may cause difficult to predict implications in more complex data models. I would recommend probably to use RELATED measure (but I am not an expert [yet]) ;)

[yurobert]

Cool, it is quite like those Entity Relationship diagrams.

[sergiohargrow]

Following your YT channel and part of the Analyst Builder community. Thank you for all of your knowledge spilled out to others to make us better. I did have a question at the 7:45 mark. When it comes to the cross filter direction, should it always be listed as both for any relationship? Or is it specific to what the needs are of the data?

[LindyLentz]

Really enjoying your videos. Makes it so much easier. Thank you

[adedejiwuraolaelizabeth]

Dear Alex,

Thanks for all you do, I really appreciate all the tutorials you put in here.

This is just to notify you that I have been finding it difficult to download the dataset. I have tried all means but it is still the same, but it wasn't like this before.

Kindly help look into it.

Thank you.Regards.

[Vikram_]

Thank you, the relationship expert! ;-)

[samuelnwakolam]

@alex the analyst when you were studying to become a Data analyst did you remember everything you trained for when you finally got a job or did you have to retrain again on the technical skills that were difficult for you ?

[felixc.programs]

Wow this one was good! Thank you for always inspiring me to grind harder, whether at work or on YT. Keep doing what you do!

[shyam.upadhyay]

So, this basically how you do left/right joins in data.

[LIV-FREE-VET]

yea thanks for the relationship advice!

[ronykeya]

Is there a reason why the output against each store still shows 10 for me even when I change the cross-filter to both like Alex did?

[akhlaquesiddiqui]

Hi Alex, please guide to install power bi for mac machine

[wongyitching]

As a beginner, I think this video is a little bit harder than other tutorials (SQL, Tableau)