Skip to main content

Power BI

Needs Votes

Possibility to have fiscal calendar in Date slicer

Vote (44) Share
Arun's profile image

Arun on 18 May 2017 14:45:25

currently there is no way to specify week start, fiscal year start in the relative date slicer

Comments (3)
Arun's profile image Profile Picture

Isaac Williams on 22 Mar 2023 15:22:56

RE: Possibility to have fiscal calendar in Date slicer

This should be merged with an older idea on the same topic.https://ideas.powerbi.com/ideas/idea/?ideaid=c58ddf2d-959f-4618-a617-4937c730c224

Arun's profile image Profile Picture

Lenzy Petty Jr on 13 May 2021 11:40:40

RE: Possibility to have fiscal calendar in Date slicer

Tableau has had a fiscal calendar option for years. Makes it soooooo easy to work in fiscal dates. Tableau delivers a fiscal date solution out of the box. So, you don't spend hours in the difficult gymnastics of DAX or Power Query solutions trying to get a fiscal date view. I love Power BI, but hate the work and limitations of I face due to the lack of an easy built in fiscal calendar solution.

Arun's profile image Profile Picture

Chris99 on 05 Jul 2020 23:34:02

RE: Possibility to have fiscal calendar in Date slicer

Excellent idea, although I'm not sure how you would configure the fiscal calendar start and end dates, how many fiscal weeks and months there would be, and how the weeks/months would be allocated to fiscal quarters.