Filtering data into a smaller dataset is a very important feature to implement when building dashboards. The reason is that people want to have a large amount of data available to them, but they do not want to have to see all of it at once; otherwise, it will become overwhelming for the users. It will require the users to hunt for data, which is not the purpose of a dashboard.
In our example, we will be selecting from a list of regions that will populate a gauge value appropriately:
Have your data list ready. In our example, we will show a simple list of five elements with their corresponding values, as shown in the following screenshot:
Select a List Box selector from the Selectors section of the Components window and drag it onto the canvas.
In the general section of the List Box selector, bind the labels to A2:A6, source data to B2:B6, and destination to D2, as shown in the following screenshot. Select Row as the Insertion Type....