web
You’re offline. This is a read only version of the page.
close
Skip to main content
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)
  • Community Member Profile Picture
    Community Member on at
    RE: How to show the percentage on a bar chart/stacked bar chart

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

  • Suggested answer
    Community Member Profile Picture
    Community Member on at
    RE: How to show the percentage on a bar chart/stacked bar chart

    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
    RE: How to show the percentage on a bar chart/stacked bar chart

    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
    RE: How to show the percentage on a bar chart/stacked bar chart

    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
    RE: How to show the percentage on a bar chart/stacked bar chart

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

  • Suggested answer
    Rawish Kumar Profile Picture
    Rawish Kumar 13,758 on at
    RE: How to show the percentage on a bar chart/stacked bar chart

    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
    RE: How to show the percentage on a bar chart/stacked bar chart

    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
    RE: How to show the percentage on a bar chart/stacked bar chart

    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.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Aric Levin - MVP Profile Picture

Aric Levin - MVP 2 Moderator

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#3
MA-04060624-0 Profile Picture

MA-04060624-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans