web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / How to show the percen...
Microsoft Dynamics CRM (Archived)

How to show the percentage on a bar chart/stacked bar chart

(0) ShareShare
ReportReport
Posted on by Community Member

Hello experts,

We encountered this problem when customizing the dashboard for an entity. The client wants to see the percentage of the total margin (total margin% = margin per file (sum)/revenue per file (sum), we are thinking to create a bar chart with two columns (sum of margin and sum of revenue), question remains for how to show the percentage ? Does anyone has some advice on this subject ?

Thank you and have a nice day !

Best regards,

Yi

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Rawish Kumar Profile Picture
    Rawish Kumar 13,758 on at

    Hi , please see below if useful.

    crmchartguy.com/.../add-percentage-labels-to-a-100-stacked-bar-chart-in-ms-dynamics-crm

    i have used it to show the count you can show % as well.

  • Community Member Profile Picture
    Community Member on at

    Hello Rawish, thank you for your reply, actually I have checked out the link before and it's for 100 stacked bar charts and not stacked bar charts. I think to show the percentage on a stacked bar chart is more of a question of calculation than a question of display.

    Cheers,

    Yi

  • Suggested answer
    Rawish Kumar Profile Picture
    Rawish Kumar 13,758 on at

    okay , kindly export the XML and try to play around with it.

    will also do something in my trial

  • Community Member Profile Picture
    Community Member on at

    Thank you Rawish, the xml has been exported just have to figure out the way to let it do the calculation haha :)

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Yi,

    Please try this:

    <Series ChartType="StackedColumn" Font="{0}, 9.5px" LabelFormat="#' %'" IsValueShownAsLabel="True" LabelForeColor="59, 59, 59" CustomProperties="PointWidth=0.75, MaxPixelPointWidth=40" />

    Thanks

  • Community Member Profile Picture
    Community Member on at

    Hello Ridhima, thank you for your reply. We've tried this method before but it only added a percentage sign to the figure (ex: total margin is 400, and now it showed as 400%), because there is no calculation behind to define the percentage of total margin vs total revenue.

    Cheers,

    YI

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi Yi,

    We cannot do calculation in XML.

    You can use high charts if you want to show calculation along with %.

    Hope it helps,

    Thanks

  • Community Member Profile Picture
    Community Member on at

    Did you find any solution to this ever? We are facing the same issue and need percentages in stacked column charts?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans