Forum Discussion

ZoraH's avatar
ZoraH
New Member
4 years ago

Timeline Slicer - Fiscal Year issue~

Dear Sir,

 

My Fiscal Year starts in the month of April.

EX:2018/04/01- 2019/03/31  is FY18

        2019/04/01 - 2020/03/31 is FY19

 

But use the timeline

the 2019/04/01 will show 2015 Q1

the quartor is correct but the year is not correct.

I find one topic as below

https://community.powerbi.com/t5/Desktop/Timeline-Slicer-Fiscal-Year-issue/m-p/87774#M36802

 

but the solution is not correct for me

 

 

Please help me to fix this issue 

 

 

3 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support

    Hi ZoraH ,

     

    For this visual object, timeline visuals can accept only “Date” values(Consecutive dates). Therefore, we cannot apply anything other than date values to this slicer.

     

    Then you can directly set the month of the beginning of the fiscal year in Format your visual->fiscal year or day

     

     

    Also, for more info you can read below blog:

    Power BI TimeLine | How to Create Interactive Timeline Slicer in Power BI? (wallstreetmojo.com)


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Dear v-henryk-mstf,

     

    I try to set the fiscal year from Apr,

    the quarter is right, but the year is worng 

     

    for example

    2018/04/01- 2019/03/31  is FY18

    2019/04/01 - 2020/03/31 is FY19

     

    the 2019 Jan to Mar is fiscal year 2018 Q4

    the 2019 Apr to Dec is fiscal year 2019 Q1 to Q3

     

    but in the timeline, the 2019 Apr show 2020/Q1

    it is not correct for me.

     

     

     

     

     

    • ZoraH's avatar
      ZoraH
      New Member
      Cause the Timeline set the fiscal year is different with my data (as I say before, timeline set the fiscal year is the year +1, but my data is year -1).
      I create a new table to set the fiscal info(set the fiscal date) and link with my data.
      it can show the correct date and data for the Timeline. thank for your helping.