 Hey guys, welcome to SSUnited Society side and this is continuation of Power BI tutorial. So today we are going to discuss a very important topic in the data modeling that is relationships. So why relationships are important and how we can build the relationship between the tables basically in this video. So we had made a great progress inside the query editor. Now we are going to build the relationship between the tables. So go to on Power BI desktop and we will see in the practical. So let's get started. So here as I told you here we are having three tabs. First is the report view, then data view, then relationship view. So we are having total three tabs. In the relationship view we can also call this as model view. So here I am going to create a visualization and we will try to understand about the relationship by using that visualization. Visualization will be covered in the upcoming videos. So here as you can see this is the visualization. So here we are having a lot of visualization are available. If you want more then you can click over here and you can import from any file or you can import from marketplace. So these are the options available and we will cover once we understand about the visualization. So here I am going to use the basic column chart. So this is the column chart. So what we want to do next we just want to get the total view by country wise. So here go to on the final fact table that is country sales final after that here as you can see we are having all the columns here let me find out for total view and this is need to drag and drop inside the values. So here we are having only one that is good but we want get this data in country wise. So go to on dimension address table and here we are having the country name. So let me drag and drop this country name inside the axis. Now we can see we are having the same values and there is no any impact. This visualization is not looks good and correct because the values are same for all the countries. So why we are getting this value because we haven't created the relationship between the country sales final table and dim at this table. So first we need to create the relationship between these two tables after that this variation will looks good. So go to on model view and here as you can see we are having all these tables. You can simply press left mouse button and you can hover anywhere. So here as I told you we need to build the relationship with the dim address and dim sales final table. So we need to make the address by using address ID let me press left mouse button and drag to the country sales final table. So here as we can see it is build a relationship. Now go to on the report tab. Here again we can see we are having all the values in the blank in Canada in US in UK we are having few values. So this is not correct why it's not correct because we have created the relationship but that is not correct. So here double click on this. It is made a relationship with the line total and here we are having address ID. So it should be with the address ID. So we can go to on address ID and we try to map with the correct. So this is the address ID need to select that one and now here we can see we are having this cardinality then cross filter direction and make this relationship active. So we'll cover later in this video series now click on OK. Now go to on visualizations here it looks good in US we are having total due amount that is after the Canada then France then UK then Germany then Australia and then we are having blank. So this is the values and it looks good and the correct values are coming. So this is the relationship and because we are having more than one tables and we are getting the data so we need to make the relationship on that here we are having few limitations because here as you can see we cannot create the relationship by using more than one columns. For example if we want to select these two then we cannot. So we have to make the relationship only a single individual column. So this is the first limit limitation. So this is the importance of the relationship that we need to create in the next videos we'll see about the cardinality and cross filter direction and make this relationship active. So thank you so much for watching this video if you like this video please subscribe our channel to get many more videos don't forget to press the bell icon to get the notification of our newly uploaded videos. Thank you so much.