How to Apply Dynamic Numeric Range Filtering in Bold BI Dashboards

Implementing dynamic numeric range filters in Bold BI dashboards allows users to interactively adjust the data displayed based on specific numeric ranges. This can be particularly useful for analyzing datasets that vary over time or across different numerical values. Below is a guide on how to set up dynamic numeric range filters for a column in a Bold BI dashboard.

Steps to Set Dynamic Numeric Range Filters

Step 1: Configure the Dashboard Parameter

• Navigate to the data source you wish to edit.
• Click on the Dashboard Parameter icon to create a Numeric Range type for your dashboard parameter.
  
  

• In the Dashboard Parameter window, set the mode to literal.
• Ensure the type is set to number and the selection type is Range.
• Define the initial start and end values for the range.
  
  

Step 2: Modify and Save the Data Source Changes

• Switch to the Code view of your data source.
• Add a WHERE condition to your SQL query or code.
• Use the numeric column name followed by the @ symbol to incorporate the start and end range parameters.
• Save the changes to the data source.
  
  

Step 3: Visualize the Results

• After setting up the dashboard, open it to the designer Preview or Published mode.
• Click on the Dashboard Parameter icon.
  
  
• Adjust the start and end values as needed to filter the data.
  
  

• The dashboard will now update to reflect the data within the specified numeric range.
  
  

Important Note

While dynamic range filtering is a powerful feature, it’s important to be aware that using the code view for this purpose may affect the performance of the dashboard. It is advisable to assess the potential performance impact before implementing this feature.

Additional References

Refer to the following resources for further information on configuring and using dashboard parameters in Bold BI:

1. Configuring Literal Mode Dashboard Parameter
2. Uses of Dashboard Parameter in Query Editor Window

By following these steps, you can effectively set up dynamic numeric range filters in your Bold BI dashboards, enhancing the interactivity and analytical capabilities of your data visualizations.