MicroStrategy - Filtering Data in Dashboard

A dashboard is a document containing many visuapzations 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 visuapzations 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.

Step 2

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

Step 3

After applying the filter, cpck 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.