Fiscal Year Customisation for Visualisations
It would be very useful if we could set our fiscal year somewhere and have that utilised by charts. This could possibly be done either as a global setting or per chart.
Currently to display fiscal year in a coherent way on visualisations we have to add a custom column to our date tables that will generate an appropriate label for charts e.g. (01) - Oct, (02) - Nov if your fiscal year starts in Oct.
It would be much friendly if we could instruct visualisations where our fiscal year begins and have them intelligently label axis.
I've noticed that if you are using a date field on the axis then visuals will change the labels based on various factors. For example for a certain period it may show individual dates, or months, or years depending on the size of the chart and other factors.
This doesn't work with custom labels though and because you cannot add two labels to an axis e.g. months AND years I cannot have a chart easily stretch and represent a period longer than a year when using fiscal year labels.
Hope this makes sense :-)
Ana Salazar commented
Really needed on the financial sector. Please add. The workaround is messy
Russell Kallman commented
Even SAP Analytics has done this really well
This is heavily needed. Would also like to see the relative data slicer to include months, month (calendar), and months (Fiscal)...this is BADLY needed, (in addition to years, years( calendar), years (Fiscal).
Andreas Hälbig commented
Yesterday we tried to solve the problem with our FY ending in Oct. Not so easy, you have to create a new date table and add this deferring date in fact table. Be so kind to add the feature, so we can solve this problem very easy
This would be great to see! My company is a May year end, and reporting for the fiscal year & fiscal quarter needs to be set up by each individual user. It would be great if this could be a global setting!
Matthew Tatsch commented
Would love to see something like this. Spotfire has a decent implementation of such a feature, wherein you configure a FiscalYearOffset parameter at the document level (e.g. if your fiscal year starts June 1 of the prior calendar year, you enter FiscalYearOffset of -7). This creates a fiscal date hierarchy - year, quarter, month, etc. - that is usable just like calendar date.
Alejandro Pelaez commented
Please, this is very important to large corporations that usually have a FY not matching the calendar year. See how the competitor is doing it. FY start month is an attribute of any date field, a way to make it even better would be allow users to pick date by date and the competitor or to have a over all set up for the whole report
Raphael Nash commented
our fy starts in July so it would be great if we had time intelligence based on fy
Evan Essig commented
I voted for this. My organization is planning to transition to Power BI, but a feature as simple as this is criticial for slicing our financial and budgeting data. I'm shocked that this isn't a built in feature.
We are using fiscal year for reporting starting on the first week with 4 days and fiscal periods with the 4-4-5 week schema. Usually we are reporting on the full last year with the current running year and last years fiscal period with the current period.
I think it's nuts that we have to create date tables to manage different financial month numberings. Still also doesn't make it easy to use OOB slicer to so financial quarters.
I'm using month name ('MMM') as a slicer and want to show months according to fiscal month name rather than the calendar month name. I could associate a number with each month name (01 Oct, 02 Nov etc.) in my data source but that wouldn't be aesthetically pleasing when presented in a dashboard. There should be a user friendly way to order/reorder month name.
Dan Day commented
This is definitely needed. Our financial year starts 1st April (no joke!) so our Q1 shows as Q2 on PBI which is very confusing for our end users.
As mentioned you may be able to create a work-around, but it would be much better if we had 'an option when adding a date axis to specify the start of financial year if not January
Cognos has supported the idea of a Fiscal year since the 90's You tell the model what date (Month/Day) that all fiscal years start on and then the builtin "Time Intelligence" functions use *either* calendar or fiscal years
Kristian Strub commented
Hi there. While I agree that there should be some easy setting to adjust FY settings other than Jan-Dec, if you are already setting up a date table either that you link to your data set or configure using a calculated table, you can do this quite easily on your own, with just a little DAX.
Here is one I use to create a column reflecting my organizations FY (July-June):
DateFY = IF(DateKey[DateMonthNumber] > 6, DateKey[CY Year] + 1, DateKey[CY Year])
After setting up a calculated date dimension table with a Calendar Year column and a month number column, you realign your Fiscal Year, as shown above. If you are working with very large datasets, might be best to configure a date dimension table in another source, and connect to it to save on memory consumption.
Of course, as calculated column value, you can use it as a filter or use is as your configured Fiscal year, Fiscal quarter, month, and day values in your shared axis of a graph to customize your drill down.
It's a bit more complicated than it needs to be, and it would be nice to be able to just adjust the native setting in your Power BI Desktop to have your date values reflect your FY FQ needs, but give the above a try. It works well enough for me!
Mitchell Reece commented
In the Xero reports, if you select a fiscal year which is July to June, the report displays as January to December. So the data goes Jan 2016 -> June 2016 then July 2015 -> December 2015.
Please any BI developer or Power BI team have look at this problem and suggest me solution or Power BI team please make this your next up gradation in your tool it is too higher in priority for Visula Dashboard.
Tableau has this feature in built but i am die heart fan of Microsoft tool and want to use always this.
I want to change default fiscal year of power Bi as per client requirement and i also need drilling down into fiscal year to get information at every layer.
Sam Dufton commented
Drilling down into fiscal year would be useful. Data can currently only be represented in fiscal year order if you sacrifice the ability to use the date functions.
yes, a fiscal year slicer that allows the user to set the fiscal year beginning month would be very helpful. the option to show fiscal year quarters would be an added bonus.