Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Timeline Slicer - Fiscal Year issue

Hi,   I have downloaded the timeline slicer from the visual gallery.   However, I find I can't seem to map the fiscal year correctly using the settings. I have data from Oct 2013 till Sept 2016. ...
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    Anonymous

     

    Please try to create another date column by adding one year and drag this column into timeline visual.

     

    Date_New = 
DATE ( YEAR ( Table1[Date] ) + 1, MONTH ( Table1[Date] ), DAY ( Table1[Date] ) )

     

    Best Regards,

    Herbert

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

Anonymous

 

Please try to create another date column by adding one year and drag this column into timeline visual.

 

Date_New = 
DATE ( YEAR ( Table1[Date] ) + 1, MONTH ( Table1[Date] ), DAY ( Table1[Date] ) )

 

Best Regards,

Herbert

  • mbwt's avatar
    mbwt
    Helper I
    9 years ago

    Hi,

     

    Does anyone know how to make the Visual:  "Timeline.1.3.17" from Power BI Visuals Gallery...  map to Microsoft's fiscal year calendar?  Thank you!

    • hmokkapati's avatar
      hmokkapati
      Helper II
      9 years ago

      Hello mbwt,

       

      Were you able to find any resolutions to this?

       

      Thank You,

      Harisha 

  • Rythalor's avatar
    Rythalor
    New Member
    1 year ago

    Please can I ask how you add this column to the data source using the above code, every time I have attempted to do this I keep getting an error stating 'Expression.Error: The name 'DATE' wasn't recognised. Make sure it's spelled correctly.'