MicroStrategy ONE

Use a Visualization to Filter Data in a Different Dashboard

Starting in MicroStrategy ONE (September 2024), you can link visualizations to dashboards in a different project.

You can use a visualization in one dashboard to link and filter data in a different dashboard. First, a visualization is defined as the source. Then, a contextual link is defined to target the selected page from a different dashboard. The visualizations in the target dashboard page are filtered based on the specific data point selected in the source. Additionally, the filter selections that the user makes in the Filter panel or in individual visualization (in canvas) filters can also be passed or matched with the filters in the target.

  1. Open the dashboard you want to modify.
  2. Hover over the visualization to use as the source, click More in the top right corner and choose > Create Contextual Link.
  3. In the Contextual Link dialog, click the folder icon .

  4. Choose a dashboard in the same project or starting in MicroStrategy ONE (September 2024), browse a different project and choose a dashboard.
  5. Click OK.
  6. From the Page drop-down, choose a page of the dashboard to target. All visualizations in the target page are filtered by data selected in the source visualization.
  7. In Tooltip, enter a description for your tooltip. The tooltip appears when you hover over the source visualization and links to the target page.
  8. To pass the filter panel conditions to the target page, select Pass the filter panel selections to the chapter of the target page.
  9. To pass the visualization (in-canvas) filter conditions to the target page, select Pass selections in all visualization filters to the target page.

    The attributes and metrics used in the Filter panel for both the source and target dashboards must be the same or match by filter name. See KB483883: Limitations of using a visualization to filter data in a different dashboard for more information.

  10. To pass the selected data in the source visualizations to filter the target page, select Use selections to filter target page's visualizations.
  11. Click Save.
  12. In the source dashboard, hover over the visualization and click the tooltip. The target page appears with the data filtered by the source visualization.
  13. To remove the visualization filter from the target dashboard, hover over the visualization in the target dashboard and in the top left corner, click Clear Filter .

There are a few other considerations to keep in mind when configuring contextual links. See KB483883: Limitations of using a visualization to filter data in a different dashboard for more information.

Related Topics

Visualization Filters and Selectors