Over the last few posts, we’ve shown how to use custom R visuals built by others. Today, we’re going to build our own using the Custom R Visual available in Power BI Desktop. If you haven’t read the second post in this series, Getting Started with R Scripts, it is highly recommended you do so now, as it provides necessary context for how to link Power BI to your local R ISE.
In the previous post, we created a bunch of log-transformed measures to find good predictors for Revenue. We’re going to use these same measures today to create a basic linear regression model to predict Revenue. If you want to follow along, the dataset can be found here. Here’s the custom DAX we used to create the necessary measures.
Click through for the example.