Microsoft Dynamics 365 | Integration, Dataverse...

Chart colours not correct in D365 but are correct when editing Dashboard in Power Apps

(0) Share

Report

Posted on by MikeExeter

Hi All

The problem is attached with screenshots. But basically I changed the Palettes to 'Berry' and 'Fire' in the charts xml and re-imported\updated the charts. The change shows when editing the dashboard in Power Apps but is still reverting to standard in D365 itself.

Please see the attached document.

Any ideas and suggestions to get this working properly would be greatly appreciaD365-Chart-colours.docxted.

I have the same question (0)

All responses (4)

Answers (0)

Community Member on at

Like (0)

Report

Hi MikeExeter,

Could you provide the XML of your chart for further research?

Was this reply helpful? Yes No
MikeExeter 54 on at

Like (0)

Report

Hi

Below is the xml - you will notice that I have even removed the PaletteCustomColors and have a Chart Palette of Berry:MH-_2D00_-Cases-by-SLA-Status-Over-Week-_2800_2_2900_.xml

<visualization>
<visualizationid>{63a95bc6-a3cf-ec11-a7b5-6045bd0fc65f}</visualizationid>
<name>MH - Cases by SLA Status Over Week</name>
<description>Cases and SLA statuses, such as succeeded or violated.</description>
<primaryentitytypecode>incident</primaryentitytypecode>
<datadescription><datadefinition><fetchcollection><fetch mapping="logical" aggregate="true"><entity name="incident"><order alias="groupby_column" descending="false" /><attribute alias="aggregate_column" name="incidentid" aggregate="count" /><attribute groupby="true" alias="groupby_column" dategrouping="day" name="createdon" /><attribute groupby="true" alias="groupby_slastatus" name="resolvebyslastatus" /><filter><condition attribute="modifiedon" operator="last-seven-days" /></filter></entity></fetch></fetchcollection><categorycollection><category><measurecollection><measure alias="aggregate_column" /></measurecollection></category></categorycollection></datadefinition></datadescription>
<presentationdescription><Chart Palette="Berry" PaletteCustomColors=""><Series><Series ChartType="StackedColumn" Font="{0}, 9.5px" LabelForeColor="59, 59, 59" CustomProperties="PointWidth=0.75, MaxPixelPointWidth=40" /></Series><ChartAreas><ChartArea BorderColor="White" BorderDashStyle="Solid"><AxisY LabelAutoFitMinFontSize="8" TitleForeColor="59, 59, 59" TitleFont="{0}, 10.5px" LineColor="165, 172, 181" IntervalAutoMode="VariableCount"><MajorGrid LineColor="239, 242, 246" /><MajorTickMark LineColor="165, 172, 181" /><LabelStyle Font="{0}, 10.5px" ForeColor="59, 59, 59" /></AxisY><AxisX LabelAutoFitMinFontSize="8" TitleForeColor="59, 59, 59" TitleFont="{0}, 10.5px" LineColor="165, 172, 181" IntervalAutoMode="VariableCount"><MajorGrid Enabled="False" /><MajorTickMark Enabled="False" /><LabelStyle Font="{0}, 10.5px" ForeColor="59, 59, 59" /></AxisX></ChartArea></ChartAreas><Titles><Title Alignment="TopLeft" DockingOffset="-3" Font="{0}, 13px" ForeColor="0, 0, 0" /></Titles></Chart></presentationdescription>
<isdefault>false</isdefault>
</visualization>

I'll attach the xml as a file attachment too.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi MikeExeter,

I added the Palette='Berry' to the xml of my chart and it couldn't work too. Then I edit the xml with 'Advanced Chart Editor' tool in the XrmToolBox and it can work.

Please follow the steps:

1. Open the visual editor of the chart.

2.Click the chart and you would find that Palette is not supported.

3. Click the Series, and you could change the color.

4. Click the Save and OK

5. Update your chart.

6. Its color would be changed.

Was this reply helpful? Yes No
SV-15060606-0 2 on at

Like (0)

Report

I have the same problem on my funnel chart. Custom palette colors are displayed in the graph editor but not in the actual app.

I tried the manual xml editing and the XRMToolbox "advanced color editor" with no success

Was this reply helpful? Yes No