[]
        
(Showing Draft Content)

Dynamically Filter a Chart Using a Parameter

You can use an image to dynamically change the parameter by which you filter a chart. The following steps will show you how to do so.

1. Create a Chart

Drag a column chart onto the canvas and bind your data. This chart displays Sales Amount by Product Category.

Screenshot 2025-06-30 at 10.31.46 AM

2. Add a Slicer

Drag a label slicer onto your canvas and bind it to your Product Category data.

Screenshot 2025-06-30 at 10.33.12 AM

3. Add Image

Add an image scenario to your canvas and upload an image to it under Source in the Inspector Tab.

Screenshot 2025-06-30 at 10.42.18 AM

4. Disable Cross-filtering

Disable cross-filtering by selecting the label slicer and clicking on the link button on the bottom ribbon. Screenshot 2025-06-30 at 10.43.07 AM Click on the link on the chart to disable cross-filtering.

Screenshot 2025-06-30 at 10.43.27 AM

5. Add Parameter

Click anywhere on the canvas (not on a scenario) to open the dashboard settings on the right-hand menu. Click the + button next to the Parameters property to add a parameter. Set your parameter value to String and select MultiValue.

Screenshot 2025-06-30 at 10.48.14 AM

6. Filter by Parameter

Filter the chart by your parameter. Click on the chart and locate the Filter button, from where you choose the General tab to select your parameter from the dropdown.

Screenshot 2025-06-30 at 10.49.55 AM

7. Add Command to Image

Next, select the image to open the image properties in the Inspector Panel. Next to the Command property, click +. In the Command Setting window set the Value Type to Slicer and set the Parameter Value to Label Slicer.

Screenshot 2025-06-30 at 10.53.19 AM

8. Preview the Dashboard

Preview your dashboard. Click on the slicer to select the categories you would like to filter for, and then click the image to apply the filter.

Screenshot 2025-06-30 at 10.58.22 AM