[]
        
(Showing Draft Content)

Filter Scenarios Using Parameter-Driven Text and Date Range Slicers

In dashboards with large categorical dimensions, binding slicers directly to dataset fields can introduce unnecessary performance overhead. Each slicer bound to a dataset triggers pivot queries at load time, which can significantly impact dashboard responsiveness—especially when dimension tables contain thousands or millions of values.

To address this, Wyn allows slicers to write values to parameters, which can then be used to filter visualizations without directly binding slicers to dataset fields. This approach enables flexible, user-driven filtering while avoiding the cost of loading and rendering large categorical lists.

The following example demonstrates how to filter a column chart by a value typed into a text slicer.


Scenario Overview

The column chart displays Gross Profit by Product Line, where the category axis contains values such as:

  • Camping Equipment

  • Golf Equipment

  • Mountaineering Equipment

  • Outdoor Protection

  • Personal Accessories

Instead of using a slicer bound to Product Line, the user types a value into a text box. That value is stored in a parameter and applied as a filter to the chart.


Step-by-Step Example

1. Create a Column Chart and Bind Data

Drag a Column Chart onto the dashboard canvas.

Bind:

  • A numerical field (for example, Gross Profit) to the Values slot.

  • A categorical field (for example, Product Line) to the Category Axis.

At this stage, the chart displays Gross Profit grouped by Product Line.



2. Add a Text Box Slicer

Drag a Text Slicer onto the dashboard.

This slicer will not be bound to any dataset field. It is used purely as a free-form input control.



3. Add a Parameter and Bind It to the Slicer

Open Dashboard Settings and navigate to General.

Create a new parameter (for example, ProductLineParam) with a String data type.

In the Binding tab:

  • Set Source Type to Slicer

  • Set Bind To to the Text Slicer

This configuration ensures that any value typed into the text slicer is stored in the parameter.



4. Apply the Parameter as a Filter on the Column Chart

Select the column chart and click the Filter icon.

  1. Click Add + to create a new filter.

  2. In the General tab, locate the search bar.

  3. Click the pencil icon next to the search field.

  4. Select the parameter (ProductLineParam) as the filter value.

Configure the filter so that the categorical field (Product Line) is compared against the parameter.

The chart now listens to the parameter instead of a dataset-bound slicer.



5. Preview and Filter the Chart

Switch to Preview mode.

Type a value such as:

Camping Equipment

into the text slicer.

The column chart updates to show only the matching Product Line.

No categorical slicer values are loaded, and no additional dimension pivots are triggered.



Applying the Same Pattern with a Date Range Slicer

This pattern also works with Date Range Slicers.

To do so:

  • Bind a date field to the chart’s category axis or filters.

  • Create a parameter bound to the Date Range Slicer.

  • Apply the parameter as a filter on the chart.

The selected date range is passed through the parameter and used to filter the visualization without directly binding the slicer to the dataset.