Power BI-Joins

 ------>In the below symbol means relationship b/w two tables.

 ----->This is the relationship b/w two tables like below.
  ------>We are not done anything for the relationship,power did automatically.
------>We need to click on Manage Relationship Option.
------>Then we can check the relationship b/w the two tables.













Comments

Post a Comment

Popular posts from this blog

Power BI-Time Series Data Visualization-Line Chart,Slicer,Card Visuals

Image
                                                                 Line Chart ------>It is the not best way to showcase Unemployment, We need to take the average, like below, ----->We can find the dropdown arrow option below, ------>Here We need to choose the Average option to get the proper Visual. ------>Now we are adding the column Gender to the L egend, Now we can get two lines (men, women) from the Chart like  below, Now the dataset has been  bifurcated. ------->We are going granular(digging down (or) going inside) wise like inside Year Quarters, Inside Quarters Months, Inside Months Weeks, Inside Weeks Days. ----->For that Granular level, we are using the  DATA/DRILL option like the below Visuals 1 )If I click Switch to the next level the Visual will show Quarter-wise across all the ...
Read more

Power BI (Introduction)

Image
                                                            Power BI ------->Once we open the power BI the first Image is like below. ------>Then we need to click on  Get started . ----->Then we get the image like below then we need to ignore the mail address later we will create and Provide, meanwhile, click on  Cancel. ---->Then click on Get Data ,  We can see here power BI is integrated(connected) to so many data sources. ----->Then click on more we can see more integrated data sources. ------> Depending on the data source we can get the data like EXCEL, CSV, PDF, JSON, etc... ------->If the data source is an excel sheet, we can click the Import data from Excel , Once click on this directly it will go to the file location like below. ------->Then we need to select the file and click ...
Read more

Power BI-Clustered Column Chart

Image
 ------->Click on the Clustered Column Chart in the visualization area. Step:-1 ------>Drag the order_date to the X-axis, After dragging it will show year,month,quarter, and day also. ------->If the date column is there in the table after dragging power internally extract year-wise, month-wise, quarter-wise, and day-wise. -------> Most clients always will ask yearly, quarterly, and monthly. Step:-2 ------->Drag the sum of the sales column to the Y-axis after dragging the visual like below. Step:-3 -------> Legend means label it will thereafter Y-axis like below. ------->If we want region-wise sales then we can drag the region column into the Legend . ------->Then the visual like below. -------> Legend is like a group by operations. Realtime:- ------->If you have 4 products there If you want to see the sales of every specific product wise with the help of legend we can get it like region in the visual. -------->For example we remove the legend ...
Read more