[]
        
(Showing Draft Content)

Pass Dynamic Parameter to Direct Dataset

You can pass a dynamic parameter (a parameter bound to a slicer whose data is from a query, or a parameter bound to a selected value) to a direct dataset. For this, you need to bind the slicer fields and chart fields to the direct dataset and this direct dataset can be the same or different for the slicer and chart.


Example: In this example, we will bind a Label Slicer and a Column Chart to the same dataset.

  1. There is a dataset(Office-Supplies-Original) with a parameter 'Parameter1' as shown below

    Office-Supplies-Original-Parameter1


  2. Apply Filters, using the Parameter1. In this example, we have applied filters on the field Location, as shown below.

    Apply-Filter-Using-Parameter1


  3. Duplicate the dataset(Office-Supplies-Original-Copy), and remove the parameter and the filter. The purpose of the step is to create data to provide available parameter values.

  4. Create a dashboard and add a label slicer, bind it to 'Office-Supplies-Original-copy', and add Location to the slicer's Columns field.

    Bind-Slicer-With-LocationField


  5. Create a dashboard parameter (Parameter1) and bind it to the slicer.

    Add-Dashboard-Parameter


  6. Create a Column Chart, bind it to 'Office-Supplies-Original', and drag Location to Axis (Category) and Quantity to Values.

    Bind-Column-Chart


  7. Click Set Parameter Values to open the Set Parameter Values.. dialog box.

    Click-Set-Parameter-Values-Option


  8. Bind to Parameter1. As we have set the default value to Mumbai in the dataset while defining the parameter, so it is displaying the default value here

    Bind-Parameter


  9. Click any item on the slicer, the data will be displayed on the chart as per the direct dataset.

    Final-Preview