Skip to main content

Notifications

Announcements

No record found.

Customer experience | Sales, Customer Insights,...
Answered

Max chart in dashboard

(0) ShareShare
ReportReport
Posted on by 1,229

Hi,

Is anyone know what is the max of the chart can cater in 1 dashboard and interactive experience dashboard?

Thanks.

Regards,
Teh

  • cloflyMao Profile Picture
    cloflyMao 25,202 on at
    RE: Max chart in dashboard

    Hi Teh,

    Yes, because number of components is limited.

    To display more charts in dashboard,

    a workaround is that creating our custom chart by 3rd party chart libraries such as Chart.js or Plotly.js, then add a large size web resource component with custom charts to the dashboard.

    We could use aggregate FetchXML queries to get result that we want.

    https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/use-fetchxml-aggregation

    e.g:

    Create a same datasource as "Active marketing emails" chart by FetchXML aggregation parameters.

    1. Download chart xml definition and copy the fetchxml from the file.

    pastedimage1590127458566v1.png

    2. Change alias of attributes to what we want:

    pastedimage1590127529619v2.png 

    3. Run code above in console for test,

    from output, we get a same datasource as default chart:

    2313.JPG

    Then we could integrate it with Chartjs and display more charts in dashboard, because there is no limit in our own web resource.

    Code:

    var fetchxml = ''
          ''
          ''
          ''
          ''
          '';
    
    var query = "?fetchXml="   encodeURIComponent(fetchxml);
    
    Xrm.WebApi.retrieveMultipleRecords("msdyncrm_marketingemail", query).then(
        function success(result) {
            for (var i = 0; i < result.entities.length; i  ) {
                console.log(result.entities[i]);
            }
        },
        function (error) {
            console.log(error.message);
        }
    );

    Regards,

    Clofly

  • Venedict Profile Picture
    Venedict 1,229 on at
    RE: Max chart in dashboard

    Hi Clofly,

    So no way I can change the number of components in dashboard. I can only create more dashboard once the limit is hit.

    Correct?

    Regards,

    Teh

  • Verified answer
    cloflyMao Profile Picture
    cloflyMao 25,202 on at
    RE: Max chart in dashboard

    Hi Teh,

    I have tried both option 1 and option 2 in tutorial below:

    https://msdynamicscrmblog.wordpress.com/2014/05/23/how-to-change-the-dashboardsettings-of-maximum-controls-limit-in-dynamics-crm20112013/

    Option 1:

    To change dashboard setting, we need to run command "Get-CrmSetting -SettingType DashboardSettings" in module "Microsoft.Crm.PowerShell", however, it seems the module is only available in on-prem server.

    The modules which support online environment are: "Microsoft.Xrm.Tooling.CrmConnector.PowerShell" and "Microsoft.Xrm.Data.Powershell",

    unfortunately, I didn't find command to change dashboard setting from those two modules.

    pastedimage1590118328353v1.png

    Option 2: 

    In online environment, I found that we could only use organization service and discovery service,

    but deployment service is only accessible in on-prem env.

    So in a word, changing components number of dashboard by code is not supported in D365 online version.

    Regards,

    Clofly

  • Venedict Profile Picture
    Venedict 1,229 on at
    RE: Max chart in dashboard

    Hi Clofly,

    It seem like D365 Online doesn't allow to change, seem only applicable to on-prem.

    Are you able to change for D365 Online?

    Thanks.

    Regards,
    Teh

  • Venedict Profile Picture
    Venedict 1,229 on at
    RE: Max chart in dashboard

    Hi Clofly,

    Thanks for your prompt reply.

    Will try out the powershell way.

    Regards,

    Teh

  • Verified answer
    cloflyMao Profile Picture
    cloflyMao 25,202 on at
    RE: Max chart in dashboard

    Hi Teh,

    There are two claims, you could take both of them as reference:

    1. The maximum number is 6, and it could be increased to 20 by code.

    A dashboard can contain charts, grids, IFRAMEs, or web resources. By default, a single dashboard can contain up to six of these components.

    https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/developer/customize-dev/understand-dashboards-dashboard-components-formxml#dashboard-components

     You can change the number of components to be displayed on a dashboard using Windows PowerShell by setting DashboardSettings.MaximumControlsLimit property.

    https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/developers-guide/gg594397(v=crm.8)?redirectedfrom=MSDN (*)

    https://docs.microsoft.com/en-us/dotnet/api/microsoft.xrm.sdk.deployment.dashboardsettings.maximumcontrolslimit?view=dynamics-deployment-ce-9

    (Confirmation is needed to claim 1, because the doc(*) stated that DashboardSettings.MaximumControlsLimit applies to Dynamics 365 (online),

    however, from other answers in forum, it seems that the proerty only works in on-premise.)

    2. The maximum number is based on user count. (Online environment)

    https://cargas.com/blog/now-you-can-have-more-than-6-dashboard-components/

    Regards,

    Clofly

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,162 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans