MicroStrategy - Filtering Data in Dashboard

A dashboard is a document containing many visualizations displaying the results simultaneously. While carrying out data analysis, we may need to apply filter which will show the effect of the filter on each of the visualizations present in the dashboard. Also, all the results should have a synchronized value. This is possible by creating a normal filter and applying it to the dashboard.

Following is an example of applying a filter to the dashboard.

Step 1

Let’s consider the dashboard which we created in the last chapter. Let’s create a filter as shown in the following screenshot.

Dashboard Filters 1

Step 2

Click the Select Target option and apply the filter to visualization2. This will change the displayed values in visualization2, however visulaization1 will display a synchronized result.

Dashboard Filters 2

Step 3

After applying the filter, click some of the values of the product category visible in the top bar filter section. This will change the diagrams, depending on the value selected. In the following example, we have selected multiple values and you can notice how the pie-chart changes as each of the values are selected.

Dashboard Filters 3