Filter Dashboard Visualization by a Parameter-Bound Slicer

The following tutorial explains how to filter a dashboard visualization by a parameter-bound slicer.

This tutorial has been created using the Technology Dataset which can be downloaded here.

TechnologyDataset.cdst

1. Create a Column Chart

   Drag and drop the column chart scenario onto the dashboard designer.

   
   

2. Add Data

   Add "TechnologyDataset" in the data binding tab.

   
   

3. Bind Data

   Bind the Ticket value to the Value axis and the TicketRaisedDate(Month) value to the Category axis. Click on the gear icon on "Sum of Ticket" and set the Aggregation Method to Count.

   
   

   
   

   
   

4. Add a Parameter

   Click Document Settings in the toolbar or click anywhere on the canvas to show the Dashboard properties in the Inspector Panel. Click the + button next to the Parameters property. Set the Data Type to String and enable Multivalue. Add three static values and set them to 1, 2, and 3, respectively. In the Binding tab, set the Source Type to Selected Value and bind it to [TechnologyDataset].TicketRaisedDate(Month).

   
   

   
   

   
   

5. Add a Label Slicer

   Drag a Label Slicer to the dashboard designer.

   
   

6. Bind to Slicer

   Select the slicer and open the Inspector Panel. Under the Interaction property group, set the Default Value property of the slicer to the parameter created.

   
   

7. Preview Dashboard