Skip to main content

Power BI

Under Review

Allow R functions to transform data before graphing.

Vote (40) Share
TS's profile image

TS on 25 Apr 2016 02:59:25

Let custom R script modify current tables, and let the result set be returned back into PowerBI's charting capabilities. This is similar to the idea of having custom SQL statements as filters for your data source. Having R functions modifying your data before graphing is even more powerful.

Comments (2)
TS's profile image Profile Picture

definitely on 05 Jul 2020 23:08:52

RE: Allow R functions to transform data before graphing.

Great idea. Also would be helpful to be able to create new variables/fields in R to merge into existing tables. This would enable one to utilize out of the box Power BI visualizations that enable tooltips, filtering, etc. that can't be readily done in custom R visuals.

TS's profile image Profile Picture

Michael Billing on 05 Jul 2020 23:04:55

RE: Allow R functions to transform data before graphing.

Great idea! This can eliminate some (or maybe a lot) of the use-cases where a custom visual would be necessary. An addition could be to add meta definitions for manipulating the data input area of PBI on a R Visual. Instead of Values section, you could have Value, Legend, etc.