Forum Discussion

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.

My fiscal year starts on Oct 1 2013 as FY14.. however, the slicer recognises it as start of FY13.

How does one resolve this so that the fiscal year is mapped correctly on the slicer?

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

6 Replies

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
- Anonymous
  Not applicable
  9 years ago
  Thank you v-haibl-msft BhaveshPatel!
- 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
    Helper II
    9 years ago
    Hello mbwt,
    
    Were you able to find any resolutions to this?
    
    Thank You,
    Harisha
- 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.'
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.