Filter panel allows you to view the filter options in a dedicated area of dashboard viewer instead of showing in the visualization region. By doing so, other major visualization widgets have enough space to accommodate. You can configure the filter using “” option in dashboard designer.
Please find the below steps to move widgets from dashboard design area to the filter panel,
Step 1: Open the designed dashboard based on your requirement. Here we have took "Northwind Analysis" dashboard for illustration purpose. In this dashboard, "Product Category" (combo box) widget is filter widget.
Step 2: Remove the filter widgets from the canvas, which you want to showcase in filter panel and click "Configure Filter Panel" in toolbar.
Step 3: Add the removed widgets into the filter panel. Here in this example, we have removed the "Product Category" (bound with Category Name) filter widget. So, we have added this into the filter panel now.
Step 4: Next move to window, where all the filter widgets created in filter panel will be listed, to set the master-slave actions. Here, for the master widget "CategoryName", we have set the slave widgets as "Orders placed by countries" and "Top products by orders widget". Now, if we make any change in the master widget, slave widget will be automatically updated.
Step 5: Further, click the "Update" button and click "Preview" dashboard.
Step 6: Go to the preview page and you can see the filter icon at the top-right corner.
Step 7: Click the filter icon and it will open the filter panel in the webpage, displaying all the configured filters.
Before applying filter:
After applying filter:
Above steps from 1 to 7 illustrate the procedure to move the filter widgets into filter panel of the existing dashboard reports. Now let’s see, how to create a dashboard with filter panel from scratch.
Step 8: Add the required widgets in the dashboard. For example, consider that we have added chart and grid widgets with data.
Step 9: Go to filter panel window and drop necessary fields. Example: We have added 3 fields like in the below image.
Step 10: Next move to window, where all the filter widgets created in filter panel will be listed, to set the master-slave actions. Here we have set chart widget as a slave for OrderId (first screen-shot below) and Grid widget as slave for ShipCity and OrderDate (second screen-shot below).
Step 11: Go to the preview page and you can see the filter icon at the top-right corner. On clicking, it will display the filter widgets.
Step 12: Change any value in OrderId (master), it will automatically affect the data in Chart widget (slave) like in the below image.
Step 13: Change any value in ShipCity or OrderDate (master), it will automatically affect the data in Grid widget (slave) like in the below image.
Step 14: If there are no records, while filtering data, the widget will display message like "There is no data to be displayed".
For more reference check the below link as well,
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:|
|9160||08/16/2018||08/16/2018||Dashboard Platform||Dashboard Designer|