Dynamics CRM仪表板：基于选中视图切换对应图表的实现方案咨询

Yes, you absolutely can build this functionality, and there are both custom development approaches and some ready-made solutions available depending on your Dynamics CRM (or Power Apps Model-Driven) version and requirements. Let’s break this down:

Development Implementation Options #

If you’re comfortable with custom coding, here are the most straightforward ways to build this:

1. Frontend JavaScript Web Resource #

This is the most direct approach for click-based toggle behavior. You’ll create a JavaScript web resource, bind click/selection events to your dashboard’s view controls, and toggle the visibility or data source of your corresponding chart controls.

Here’s a simplified example using the Dynamics 365 Client API:

// Initialize dashboard interactions on load
function setupViewChartToggle() {
    // Get references to your view and chart controls (replace with your actual control names)
    const view1Control = Xrm.Page.getControl("view1");
    const view2Control = Xrm.Page.getControl("view2");
    const chart1Control = Xrm.Page.getControl("chart1");
    const chart2Control = Xrm.Page.getControl("chart2");

    // Set initial state: show chart1, hide chart2
    chart2Control.setVisible(false);

    // Bind event to View 1: show chart1 when a record is selected
    view1Control.getGrid().addOnRecordSelect(() => {
        chart1Control.setVisible(true);
        chart2Control.setVisible(false);
    });

    // Bind event to View 2: show chart2 when a record is selected
    view2Control.getGrid().addOnRecordSelect(() => {
        chart1Control.setVisible(false);
        chart2Control.setVisible(true);
    });
}

To use this:

• Upload the script as a web resource in your CRM instance
• Edit your dashboard, add the web resource, and set it to execute setupViewChartToggle on load

2. Backend Plugin (For Advanced Data Sync) #

If you need to dynamically update chart data based on the view’s filter criteria (not just visibility), you could write a plugin that triggers when the view is interacted with. This is overkill for basic visibility toggles, but useful if your charts need to reflect the exact filter state of the selected view.

Ready-Made Solutions #

If you prefer to avoid custom coding, here are some options:

1. Power Apps Model-Driven Interactive Dashboards #

If you’re using the modern Dynamics 365 (Power Apps Model-Driven) platform, you can leverage:

• Component Visibility Rules: Create a hidden global option set field on a dummy entity, then set your charts’ visibility to depend on this field’s value. Use a simple JavaScript snippet (or even Power Automate) to update the field when a view is clicked, triggering the chart toggle.
• Interactive Dashboard Components: Some out-of-the-box dashboard components support basic interaction linking, though this is limited to specific scenarios (like drilling down from a chart to a view). For view-to-chart toggles, you’ll still need a small amount of low-code setup.

2. ISV Solutions #

Several Independent Software Vendors (ISVs) offer dashboard enhancement tools for Dynamics 365 that include pre-built view-chart联动 features. These are paid solutions, but they often come with additional visualization and interaction capabilities if you need more than just basic toggling.

3. Low-Code Power Automate Workflows #

For non-developers, you can use Power Automate to trigger actions when a record is selected in a view. For example:

• When a user selects a record in View 1, update a shared "dashboard state" record’s field
• Configure your charts to filter based on this field’s value, effectively switching which data they display

Final Notes #

For most basic toggle scenarios, the frontend JavaScript approach is the fastest and most flexible. If you’re working with a newer Power Apps environment, combining visibility rules with a tiny script can give you a low-code solution without full custom development.

内容的提问来源于stack exchange，提问作者Felipe Barbosa