Hi,
Is anyone know what is the max of the chart can cater in 1 dashboard and interactive experience dashboard?
Thanks.
Regards,
Teh
Hi,
Is anyone know what is the max of the chart can cater in 1 dashboard and interactive experience dashboard?
Thanks.
Regards,
Teh
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.
2. Change alias of attributes to what we want:
3. Run code above in console for test,
from output, we get a same datasource as default chart:
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
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
Hi Teh,
I have tried both option 1 and option 2 in tutorial below:
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.
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
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
Hi Clofly,
Thanks for your prompt reply.
Will try out the powershell way.
Regards,
Teh
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.
You can change the number of components to be displayed on a dashboard using Windows PowerShell by setting DashboardSettings.MaximumControlsLimit property.
(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
André Arnaud de Cal...
292,162
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156