Forum Discussion
Using gganimate from CRAN via R-script to visualize an animated component
I'm not sure what is going on. The visual I see is static, and I suspect it launched your browser when it was returning html. To see the animated visual on your Power BI report page, I suspect you are going to need to create a custom visual following the steps described here.
https://towardsdatascience.com/custom-html-visuals-in-power-bi-using-r-2b0494894ff
Here is the static chart I see with your example data.
Attached is the pbix, in case it is useful to you.
Regards,
Pat
Hi Pat,
Thank you for getting back to me.
In R-Studio this is what I get with the same dataset and code:
I checked in Power BI and there is no aggregation active (I checked for all three parameters):
Reason for those two NULL statements is due to the fact that my dataset actually has those two extra columns and I kept them in the dataset to compare the processed values with raw ones (I used as.numeric() since ggaimate requires numeric values but the raw columns were actually string). So I wanted to clean those up. After removing those NULL statements still issue is there.
I wish to note that the dataset itself was generated using an aggregated function with R script. So I added ungroup() at the end and that did nt fix it either.
I paid more attention and saw SIGMA symbols next to field names, and after 20 minutes found that summarization is active by default. Tutorials were not helpful in locating the correct tab for disabling that, finally I found it here:
After that still the issue persists.
I also tried an explicit call for animation like this:
animate(p, height = 800, width =800,fps=10)
Still no luck..
I'm not sure what is going on. The visual I see is static, and I suspect it launched your browser when it was returning html. To see the animated visual on your Power BI report page, I suspect you are going to need to create a custom visual following the steps described here.
https://towardsdatascience.com/custom-html-visuals-in-power-bi-using-r-2b0494894ff
Here is the static chart I see with your example data.
Attached is the pbix, in case it is useful to you.
Regards,
Pat
Did someone try this solution?
How would a custom visual work in Power BI for animated charts?
I ask this because I don't see how it could work...
