How to Change Fiscal Year in Tableau

If your company’s fiscal calendar doesn’t kick off in January, getting your Tableau dashboards to match your real-world business cycles is essential for accurate reporting. Luckily, changing Tableau’s default fiscal year from January to July, October, or any other month is a straightforward process. This guide will walk you through setting a custom fiscal year for your data sources and individual date fields, ensuring your reports align perfectly with your financial periods.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Does Aligning the Fiscal Year Matter?

Most business analytics revolve around quarterly goals, year-over-year growth, and period-based comparisons. When your reporting tool’s concept of a "quarter" doesn't match your company's, it creates confusion and can lead to flawed insights. For example, if your Fiscal Year 2024 (FY24) started on October 1, 2023, you need your dashboards to reflect that.

Imagine trying to analyze Q1 performance. Your business considers October, November, and December as Q1. But by default, Tableau sees January, February, and March as Q1. This disconnect means:

• Quarterly goals are misaligned with the data shown in your "quarterly" reports.
• Year-over-year comparisons become a manual, error-prone exercise.
• Conversations about "this quarter" get confusing when everyone is looking at different date ranges.

By simply telling Tableau when your fiscal year begins, you solve these problems instantly. Every quarterly or yearly view you create will automatically reflect your company's calendar, making your analysis intuitive and accurate.

How to Set the Fiscal Year for an Entire Data Source

The most common and efficient way to handle fiscal dates is to set them at the data source level. This tells Tableau to apply your fiscal calendar to every date field from that specific source. It’s a "set it and forget it" approach that ensures consistency across your workbook.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Find Your Data Source

In your Tableau workbook, look at the Data pane on the left side of the screen. You'll see your connected data source(s) listed at the top. This is where the configuration begins.

Step 2: Open the Date Properties Menu

Hover your mouse over the name of the data source you want to modify. Right-click on it to bring up the context menu. From this menu, select Date Properties...

Step 3: Change the Fiscal Year Start Month

A dialog box will pop up, giving you a few options to configure how Tableau interprets dates from this source.

• Fiscal year start: This is a dropdown menu pre-populated with all twelve months. Simply click it and select the month your company's fiscal year begins. For example, if your fiscal year starts on July 1st, you’d choose "July".
• Week start: While you're here, you can also define which day your weeks begin on (e.g., Sunday or Monday). This is useful for weekly reporting.
• Date format: You can also set a default date format for the data source.

After selecting your desired fiscal start month, click OK.

What Happens After You Change It?

Immediately, Tableau re-evaluates all date fields from that source. When you drag a date field onto a view and select a date part like "Quarter" or "Year," Tableau will automatically use the fiscal period instead of the calendar one.

For instance, if you set the fiscal start to October:

• The date October 15, 2024, will now belong to FY2025.
• The period of Oct–Dec 2024 is now Q1 FY2025.
• The period of Jan–Mar 2025 is now Q2 FY2025.

You’ll notice that when you use these fiscal dates, Tableau often labels them accordingly, like "Q1 2025," helping you keep track.

Setting a Fiscal Calendar for a Specific Date Field

Sometimes, a single fiscal calendar for the entire data source isn’t flexible enough. You might have one date field representing financial transactions (which follows a fiscal calendar) and another representing something else, like marketing campaign dates, that should follow a standard calendar year. In these cases, you can set the fiscal year for an individual date field, overriding the data source default.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

When Would You Use This?

• Cross-Departmental Dashboards: A report might track sales revenue (on a fiscal calendar) alongside website traffic (on a calendar calendar).
• Data with Mixed Sources: You might join sales data from your CRM with web analytics data. Each might need to operate on different calendars within the same view.
• Ad-Hoc Analysis: You just want to temporarily view a single chart through a fiscal lens without changing the entire data source's properties.

The process is nearly identical to the data source method, but you start from the field itself.

1. In the Data pane, find the specific date dimension you want to change (e.g., [Order Date]).
2. Right-click on the date field.
3. From the context menu, navigate to Default Properties > Fiscal Year Start...
4. A dialog box appears. Here, you can select a specific month for just this field, or you can select "Data Source" to revert it to the data source's default setting.
5. Click OK.

Now, this field operates on its own fiscal calendar, independent of other date fields and the overall data source setting.

Using Fiscal Date Parts in Your Visualizations

Once you've configured your fiscal calendar, Tableau makes it easy to use it in your charts and tables. When you drag a date field onto the Columns or Rows shelf, you can right-click the blue pill to choose which date part to display. You'll now see options for fiscal periods.

For example, if you want to show sales by fiscal quarter:

1. Drag your [Order Date] field to the Columns shelf.
2. Drag your [Sales] measure to the Rows shelf.
3. Right-click the [Order Date] pill in the Columns shelf.
4. From the menu, choose the second "Quarter" option (the one below the year, month, day selectors). This continuous quarter aggregation will respect your fiscal settings. You can also choose "Quarter(Order Date)" from the discrete section for a different look.

The resulting chart will now correctly group your data into fiscal quarters, automatically labeled and sorted according to the start month you selected.

Limitations and Troubleshooting

What about 4-4-5 or Custom Calendars?

It's important to know that Tableau's built-in fiscal year setting only supports calendars that start on the first of a specific month and follow a standard quarterly structure (three months per quarter). It cannot natively handle non-standard calendars like the popular 4-4-5 or other custom retail calendars. To work with these, you will need to create a calendar or date dimension table in your data source or use calculated fields within Tableau to manually define the fiscal periods. This is a much more advanced technique but is the standard solution for complex calendars.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Common Questions

"I changed the fiscal year start, but my old reports look the same. Why?" If a view was already built using a specific calendar date part (e.g., you explicitly selected YEAR(Order Date)), it won't retroactively change. You may need to remove the date pill from the view and add it back, making sure to select the correct fiscal date aggregation from the context menu.

"Will this change my original data?" No, absolutely not. Tableau is a read-only tool for visualization. These settings only change how Tableau interprets and displays dates within the Tableau environment. Your underlying database or source file remains completely untouched.

"I have multiple data sources. Do I need to set this for each one?" Yes. The fiscal year setting is specific to each data source. If you have a workbook with three different data connections, you'll need to go to the Date Properties for each one and set the fiscal start month to ensure they all align.

Final Thoughts

Setting your fiscal year in Tableau is a simple yet powerful step to ensure your financial reports are accurate, intuitive, and aligned with your business operations. Whether you adjust the start month at the data source level for consistency or at the field level for flexibility, you can quickly make your dashboards speak the same language as your finance and sales teams.

While mastering tools like Tableau is a valuable skill, we know the constant setup, configuration clicks, and troubleshooting for every report can be a time-consuming part of the job. At its core, that’s why we built Graphed. We wanted to eliminate the friction between having data and getting answers. Instead of navigating menus, we let you connect your marketing and sales data and build complete dashboards simply by describing what you need in plain English - no wrestling with date properties required.