Business Intelligence with MicroStrategy Cookbook

Using filters

In Chapter 12, In-Memory Cubes and Visual Insight, we learned how to control a visualization from another using the first as a filter. Now we will create a filter that affects all the visualizations in the same panel.

Getting ready

You need to have completed the preceding recipe to continue.

How to do it…

From the Express main page, click on the dashboard that we saved in the last recipe to open it:

1. Open the context menu of the visualization pane named Grid (on the right, in the title bar just before the red X), and select Change Visualization….
2. Click on the group named Matrix of bar graphs (first on the left of the second row) and pick the first thumbnail named Vertical Bar – 100% Stacked.
3. Open the context menu of the pane titled Graph ...