[]
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.
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.
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.

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.

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.

Select the column chart and click the Filter icon.
Click Add + to create a new filter.
In the General tab, locate the search bar.
Click the pencil icon next to the search field.
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.

Switch to Preview mode.
Type a value such as:
Camping Equipmentinto 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.

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.