Forum Discussion
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
Community 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. - ZoraHNew Member
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.
- ZoraHNew MemberCause 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.