Forum Discussion
creating scatter plot matrix
HI rob_mysbxsec
You can create R visuals inside Power BI, and you can probably use exactly the same code in Power BI that you used to create that screenshot
Have a read of this
https://docs.microsoft.com/en-us/power-bi/desktop-r-visuals
Thanks for response and suggestion. Yes i am aware of the that report control that allows you to incorporate R script directly to generate a report view. That said what i'd like to avoid is having to resort to R [ or Python ] script for generating visuals whereever possible and leverage power BI's feature set for accomplishing similar things.
I've tested the simple correlation matrix visual outlined as the example in the article you provided link to, i.e.
require(corrplot)
M <- cor(dataset[c('geo_level_1_id', 'geo_level_2_id', 'geo_level_3_id', 'age', 'area', 'height', 'damage_grade')])
corrplot(M, method = 'color', tl.cex = 0.6, tl.srt = 45, tl.col = 'black')
and that is great for case where R generated visual generating method call is easy to use and configure the output to look nice.
On similar front, see http://community.powerbi.com/t5/Desktop/power-bi-for-pretty-histograms/m-p/391334, its a shame that to create something as common as a histogram / frequency chart in power BI i have to go off into the query editor and create a dataset with group by column and associated count of unique values for every column[/field/variable] that i want to produce a histogram for in my report view. I would have expected that common exploratory data analysis visual to be a dragNdrop exercise unless it is and i've overlooked how to do it. Resorting to R script control to accomplish that means i'm now relegated to R hist() services for making it pretty which isn't as quickNeasy and maintainable by non-R users as doing it in power Bi would be.