選擇組織
Display future dates that are not in the data
發佈日期: Feb 24, 2026
工作
How to display future dates that are not in the data.
The example demonstrated here supposes the data source only has data through December 2022, but you want a visualization through December 2023.
步驟
Option 1
Prepare another data source with the date values you want to display and merge them.1. Create a Date Master table like the attached data source, Date Master.xls.
2. Launch Tableau Desktop and connect to the attached data source Sample - Superstore2022.xls.
3. In the Data Source tab, drag the sheet Orders to the canvas.
4. Click on Add > Connect to Date Master table.
5. Double-click on Orders on the canvas.
6. Drag the table of Data Master next to Orders on the canvas.
7. Select Full Outer to join the date fields together as shown here:
8. Move to Sheet 1. Right-click to drag Date in Master Date to Columns then select MY(Date).
Scroll to the right and you will see the 2023 frame.
Option 2
Use the date range extension feature.*If you use Option 2, the date filter may not work as desired.
The filter restriction is described in the Additional Information section.
1. Launch Tableau Desktop and connect to the attached data source, Sample - Superstore2022.xls.
2. In the Data Source tab, drag the sheet Orders to the canvas.
3. Move to Sheet 1. Right-click and drag Order Date to Columns then select Month (Order Date) for measure.
4. Right-click Month (Order Date) on Columns then select Discrete.
5. Right-click Month(Order Date) on Columns then select Extend Date Range > 1 Year.
Scroll to the right to see the 2023 frame.
其他資源
When using the "Extend Date Range" function, the specified period of time will be extended in a fixed manner.
Therefore, if a filter is used, it will always be extended by the maximum filtered value plus the specified period of time.
For example, if you filter Order Date by 2021 then the 2022 frame is also shown.
知識文章編號
001465173
此文章是否解決您的問題？
請讓我們知道，以便我們改進！
