[]
(Showing Draft Content)

Filter Compact-Date Data Using a Standard-Date Slicer

Some data sources store dates in compact numeric formats, such as 20240101, while others use standard date formats such as 2024-01-01. When you combine these datasets in a dashboard, filtering may not work as expected because the formats do not match. This feature allows you to filter a visualization that uses compact-format dates by connecting it to a slicer that uses standard-format dates.

By configuring a field-level interaction between two datasets, you can create a unified filtering experience even when the underlying data structures differ. This approach is useful when working with legacy systems, mixed-format extracts, or environments where you cannot modify the original data.

Note

If you want to recreate this example, download the sample datasets used in this article:

SalesFacts_CompactDate.xlsx

SalesFacts_StandardDate.xlsx

Prerequisites

Before you begin, ensure you have:

  • Two datasets:

    • A dataset containing compact-format date values (for example, 20240101)

    • A dataset containing standard-format date values (for example, 2024-01-01)

  • A dashboard open in the Dashboard Designer

Add Both Datasets to the Dashboard

  1. Open the dashboard in the Dashboard Designer.

  2. In the Data Binding panel, upload both datasets:

    • The dataset with compact-format dates

    • The dataset with standard-format dates


This makes both tables available for binding and interaction.

Add a Data Table and Bind Compact-Date Data

  1. From the Dashboard Visualizations panel, drag a Data Table onto the design surface.

  2. Bind the table to the dataset containing compact-format dates.

  3. In the Data Binding panel, drag fields from the dataset and place them in the table’s column bindings.


The data table now displays the unformatted, compact date values.


Add and Configure the Standard-Date Slicer

  1. Drag a Multi-Dimensional Dropdown slicer onto the dashboard.


  1. Bind the slicer to the dataset containing standard-format date values.

  2. In the Data Binding panel, drag the standard date field to the Dimension area of the slicer.


The slicer now displays readable date values.

Configure the Interaction Between the Slicer and the Table

  1. Select the slicer.

  2. On the Page Setup bar, choose Interaction Setting.


  1. In the Interaction Setting window, select the data table to enable its interaction with the slicer.

  2. Select + to add a field mapping.

  3. For Source Field, choose the standard-format date field from the slicer’s dataset.

  4. For Target Field, choose the linking field from the compact-format dataset (for example, a shared transaction or record ID).

  5. Select OK to apply the interaction.



This creates a cross-dataset link, allowing date selections from the slicer to filter the compact-date dataset.

Preview the Dashboard

  1. Select Preview from the ribbon.


  1. Choose a date from the slicer.

  2. Verify that the data table updates based on the selected date.



The compact-format date table should now filter according to the standard-format date selection.