Watch videos with subtitles in your language, upload your videos, create your own subtitles! Click here to learn more on "how to Dotsub"

2016 1 20 Analyzing and Visualizing Data with Power BI MOD2 2

0 (0 Likes / 0 Dislikes)
[Microsoft] [Male] When trying to create visuals involving multiple tables which are not related in Power BI desktop, users can automatically detect relationships or they can also set them up manually so that their visualizations work as they expect. In order to access this functionality, simply create a visual involving multiple ??? tables that are unrelated. For instance, we are going to go into the Project Hours table and we're going to bring in the project from Company Projects, and we're going to bring in the Total Hours from the Project Hours, and then we're going to bring in the Employee ID from the Company Employee table. As soon as we do this, you'll find out that the visual can be displayed, and there's this Fix This button that when you click, it will actually suggest you that there might be missing relationships between these fields. Now we can either use auto-detect or we could manually create these relationships. Let's go and try Auto Detect. Relationship Detection completes quickly and it actually found two new relationships within this model. Now once we close, you can see how the visual is rendered properly and it actually shows the three columns that you expect to see in this table based on the three fields that we had selected before. In addition to automatic relationship detection, there's a full set of capabilities inside Power BI desktop to actually define and create relationships within the Relationships view. This view is accessible from the left side of the Power BI desktop window, and it will give you a view of all the tables and relationships that exist within the current Power BI desktop file. From here, you can actually interact with these tables. You can resize them, reorder them in the screen. You also have zoom controls to zoom in or zoom out. You can also use the Fit to Screen control, and you can also reset the layout, so for instance, I drag a few fields around and a few tables around and relationships so that it breaks the default layout. I can always click the Reset button to actually go back to the original state. [Microsoft]

Video Details

Duration: 2 minutes and 25 seconds
Language: English
Genre: None
Views: 2
Posted by: mihart on Feb 9, 2016

Caption and Translate

    Sign In/Register for Dotsub to translate this video.