ggplot2 - Dplyr arrange in Power BI with R not working -
want use dplyr sort dataframe.
library(dplyr) library(ggplot2)
in r studio
arrange(mtcars, mpg)
works fine
in power bi
arrange(dataset, order)
does not work. "order" column numbers 1-100. i'm, expecting r dplyr order column numerically in ascending order. when apply bit of code, visual doesn't break doesn't anything. i.e. nothing moves or changes. i've tried column "productline" same results.
i tried going little overboard explicitly calling local data.frame tibble , calling dplyr again. still not working.
#tibble dataset <- tbl_df(dataset) as.data.frame(dataset) #dplyr stuff arrange(dataset, productline)
what missing here? why dplyr work fine in r studio not in power bi (other libraries work fine - scales , ggplot2). wrong way dataset created? strange power bi? yes, r studio , power bi using same directory (and added fodder, other libraries work fine).
Comments
Post a Comment