Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Animate Historical Trends Over Time

Hello,

 

Im trying to the build Aminated Trend line over time.

Referred the below link 

Power BI - Animate Historical Trends Over Time

https://www.youtube.com/watch?v=lOdLJx1zL7Y

Since the data I have is for Couple of Years, Im looking to convert Year to Dates so that line trend goes continuous over Year(By dates). How can I acheive this.

 

Regards

Chandra

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi,

      I am able to acheive the result as in youtube video. But my Years in X axis are not Static. 

      I have 2018, 2019 & 2020 in X axis. when I play Axis, I dont see all 3 years in X axis, as you can see for 2019, we can see 2018 & 2019 but not 2020.

       

       

      Any one have Ideas o have these 3 years fixed in X axis.

      Regards,

      Chandra

      • lbendlin's avatar
        lbendlin
        Super User

        Use the Year column from the Calendar table, not from the Facts table.