I have a custom R visualization within Power BI. The visualization works fine in my own Power BI Desktop but I am noticing some weird behavior when uploading the dashboard to Power BI Services.
When I group by a column the data such as:
dataset = dataset %>%
group_by(month, year, groupname) %>%
summarize(y = cumsum(y))
it is not grouping correctly. The groupname column will start with two different values to group, lets say "A" and "B" but when I group the data the output will be the "B" column and a bunch of different numbers like "0", "12", "2" , etc... with NA values. The whole dataset seems to be messed up. Other columns like the month and year now reading as NA instead of their original values.
There are other columns I use this same behavior on within the data.frame and these seem to group correctly except for this one. I am not sure what is causing this behavior.