Hi all, having a bit of a nightmare with my slider after adding date frame animation to my plotly chart.
Unfortunately, I am taking data from an Azure database, so can't replicate it to show you, but it is a simple scatter chart that is working fine minus the animation slider)
Original date format I'm unsure of (still a newbie!) but looks like this:
and so my line: animation_slider(currentvalue = list(prefix = "Reporting Month: "))
is working as expected.
BUT I want the format to be "%b %y"
Firstly I use df$m<-as.Date(df$m)
The prefix line doesn't work (weird), but my data looks a bit better at least (although still not the format I want)
When I format the column using:
The chart still works fine, the prefix appears (good) but I lose the date order (bad)
How on earth can have the format I want, in the order I want?! Been trying every option I can think of for days, but no luck...does anyone with more experience have an idea?
Thanks in advance!