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

BhaveshPatel's avatar
BhaveshPatel
Super User
9 years ago

Hi Ashish,

 

You can use newly added Date slicers update in the Oct Update. This will manually allow you to configure your date slicers.

 

Refer to this VIDEO.