You’re offline. This is a read only version of the page.
22
Hi
I am using D365 CE, Version - 1710 (9.1.0.6023) online
There, i have created a pie chart or funnel chart of product category wise sales total. Now, i want to change the color as per product category. Like, Gold - Yellow, Diamond - lightgray, Silver - Silver, platinum - Gray, Stone - Green.
While modifying XML of the chart, it is not appearing as per product category where as it is coming as per sales value. Like - greater total - Yellow, 2nd greater total - lightgray, 3rd greater total- Silver, 4th greater total - Gray, 5th greater total- Green.
Here is the screenshot for your reference
Here is the default XML
<visualization>
<visualizationid>{6DA54825-C391-E911-A977-000D3AF075C4}</visualizationid>
<name>Category Wise Purchase</name>
<primaryentitytypecode>acx_invoiceheaderline</primaryentitytypecode>
<datadescription>
<datadefinition>
<fetchcollection>
<fetch mapping="logical" aggregate="true">
<entity name="acx_invoiceheaderline">
<attribute name="acx_itemtype" groupby="true" alias="_CRMAutoGen_groupby_column_Num_0" />
<attribute name="acx_netamount_value" aggregate="sum" alias="_CRMAutoGen_aggregate_column_Num_0" />
</entity>
</fetch>
</fetchcollection>
<categorycollection>
<category alias="_CRMAutoGen_groupby_column_Num_0">
<measurecollection>
<measure alias="_CRMAutoGen_aggregate_column_Num_0" />
</measurecollection>
</category>
</categorycollection>
</datadefinition>
</datadescription>
<presentationdescription>
<Chart Palette="None" PaletteCustomColors="91,151,213; 237,125,49; 160,116,166; 255,192,0; 68,114,196; 112,173,71; 37,94,145; 158,72,14; 117,55,125; 153,115,0; 38,68,120; 67,104,43; 124,175,221; 241,151,90; 186,144,192; 255,205,51; 105,142,208; 140,193,104; 50,125,194; 210,96,18; 150,83,159; 204,154,0; 51,90,161; 90,138,57;">
<Series>
<Series ShadowOffset="0" IsValueShownAsLabel="True" Font="{0}, 9.5px" LabelForeColor="59, 59, 59" ChartType="Funnel" CustomProperties="FunnelLabelStyle=Outside, FunnelNeckHeight=0, FunnelPointGap=1, FunnelNeckWidth=5 ">
<SmartLabelStyle Enabled="True" />
</Series>
</Series>
<ChartAreas>
<ChartArea>
<Area3DStyle Enable3D="false" />
</ChartArea>
</ChartAreas>
<Legends>
<Legend Alignment="Center" LegendStyle="Table" Docking="right" IsEquallySpacedItems="True" Font="{0}, 11px" ShadowColor="0, 0, 0, 0" ForeColor="59, 59, 59" />
</Legends>
<Titles>
<Title Alignment="TopLeft" DockingOffset="-3" Font="{0}, 13px" ForeColor="0, 0, 0" />
</Titles>
</Chart>
</presentationdescription>
<isdefault>false</isdefault>
</visualization>
Please Help.
Thanks
Kalpamay
*This post is locked for comments
I have the same question (0)
Check out Urik's website https://crmchartguy.com/ He has great tips on changing colors and size for these charts
Share
Report
All responses (
Answers (
