MicroStrategy - Data filtering in the dashboard
A dashboard is a document containing many visualizations showing results simultaneously. While analyzing the data, we may need to apply a filter that will show the effect of the filter on each of the visualizations present in the dashboard. Additionally, all results must have a synchronized value. This is possible by creating a normal filter and applying it to the dashboard.
Here is an example of applying a filter to the dashboard.
Let's take the dashboard we created in the last chapter. Let's create a filter as shown in the following screenshot.
Clickz on the Select target option and apply the filter to visualization2. This will change the values displayed in visualization2, however visulaization1 will display a synchronized result.
After applying the filter, click on some of the product category values visible in the filters section of the top bar. This will change charts, depending on the selected value. In the following example, we have selected multiple values and you can notice how the pie chart changes when each of the values is selected.