From the course: Power BI: Integrating AI
Join today to access over 24,800 courses taught by industry experts.
Creating corrplot - Power BI Tutorial
From the course: Power BI: Integrating AI
Creating corrplot
- [Instructor] Correlation measures the strength and direction of the relationship between two variables, like measures in a Power BI model. Let's say that we want to expand our analysis to mirror all the correlations between all the variable pair combinations at the same time. Corrplot, short for correlation plot, visuals are available in the R language. To do this within Power BI, we'll use a combination of functionalities like DAX quick measures, calculation groups, and the standard matrix visual with a multitude of formatting options applied on top of it to really make it pop. Let's create our correlation plot using the matrix visual, where we'll start with the energy type labels already in the matrix for the rows, and filter to the values of coal, demand, natural gas, solar, and wind in the filters pane. These are going to match their respective measures already in the model. I already formatted the matrix visual with larger text and padding between the rows. We're going to use…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.