This article will help you set setup data filtering in an IntelliFront BI Dashboard Visual.
Dashboard - Data/Filtering
- You have the option to apply filtering to dashboard visuals, filter SQL queries or the entire data sources.
- To filter Dashboard visual go to Data/Filtering in the Binding Menu.
![KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.](https://go.christiansteven.com/hubfs/12-6-2018%203-06-52%20PM.png)
- Select Click to set Filter Criteria.
![KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.](https://go.christiansteven.com/hubfs/12-6-2018%203-07-53%20PM.png)
Filter Editor
![KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.](https://go.christiansteven.com/hubfs/12-6-2018%203-09-39%20PM.png)
- In Filter Editor setup the conditions for your dashboard visual.
![KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.](https://go.christiansteven.com/hubfs/12-6-2018%203-13-38%20PM.png)
- You can click on the And to change the logical operator.
![KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.](https://go.christiansteven.com/hubfs/12-6-2018%203-13-48%20PM.png)
- Next to the And, click on the (+) button to add a group or condition.
![KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.](https://go.christiansteven.com/hubfs/12-6-2018%203-18-30%20PM.png)
- If you add a condition, you can select the values added in the binding menu.
![KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.](https://go.christiansteven.com/hubfs/12-6-2018%203-22-38%20PM.png)
- You can set the comparison.
![KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.](https://go.christiansteven.com/hubfs/12-6-2018%203-27-36%20PM.png)
- Set the type of conditions.
- Value: You can compare the dimension and static values.
![KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.](https://go.christiansteven.com/hubfs/12-6-2018%203-25-34%20PM.png)
- Property: You can compare with different values added to the dashboard visual.
![KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.](https://go.christiansteven.com/hubfs/12-6-2018%203-29-53%20PM.png)
- Parameter: You can compare it with the Dashboard Parameter values.
![KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.](https://go.christiansteven.com/hubfs/12-6-2018%203-30-51%20PM.png)
Advanced Mode
![KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.](https://go.christiansteven.com/hubfs/12-6-2018%203-31-57%20PM.png)
- The Advanced Mode allows you to custom the filter editor using SQL queries.
- Once you finish, click OK to save.
![KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.](https://go.christiansteven.com/hubfs/12-6-2018%203-36-42%20PM.png)
![KPI's and Dashboards: Setting up Data Filtering in IntelliFront BI Dashboard.](https://go.christiansteven.com/hubfs/12-6-2018%203-37-26%20PM.png)