Manipulating Relationships In PowerBI
Start course

PowerBI videos


- Hello, and welcome to this Power BI session. In this video, you'll learn how to manipulate the relationship between visualizations in Power BI. For this example, I've uploaded some accident severity information to our existing data sets. As you can see, there isn't a relationship between these tables at the moment. The easiest way for us to connect them is to drag and drop the information like this. Now we've connected the accident severity code to the accident severity in the accidents data, so we can carry on building our relationships. Let's count the number of accidents occurring in the U.K. according to their severity. Just like in our visualizations session, Power BI has automatically selected a table view, but I'd like to see the information presented as a column chart. This visualization doesn't make any sense at the moment, because we don't know which severities one, two, and three represent. To fix this, we can add the labels to our legend data. Now we can see which color represents which information. Let's also take a look at this information as a map visualization. To do this, select the map, specify the latitude and longitude information. Because we can't get the average latitude, we have to change this as well. Now we can see our data points on a map of the United Kingdom. We can see the accident severity and even the count index here. Before we finish, I'd like to show you how to use hierarchies in Power BI. For example, day of the week information belongs within the date hierarchy. So, you can drag and drop day of the week information into the hierarchy like this, and this is the result. And that's it for this video. Thanks for watching.

About the Author
Learning Paths

A world-leading tech and digital skills organization, we help many of the world’s leading companies to build their tech and digital capabilities via our range of world-class training courses, reskilling bootcamps, work-based learning programs, and apprenticeships. We also create bespoke solutions, blending elements to meet specific client needs.