web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / Group chart in Legend ...
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Group chart in Legend series by two fields

(0) ShareShare
ReportReport
Posted on by Jose Gregorio Diaz 20

Dear support,

I am trying to replicate this chart made in excel in  dynamics 365 out of the box solution:

pastedimage1612897081636v4.png

When I am trying to build up the chart with this options below:

pastedimage1612897273217v6.png

pastedimage1612897248406v5.png

I am not able to group by an agent name in stacked columns, because is doing a "count:all"

Do you know if there is any way that I can achieve this?

Thank you in advance,

Jose G Diaz

I have the same question (0)
  • Jose Gregorio Diaz Profile Picture
    Jose Gregorio Diaz 20 on at
    RE: Group chart in Legend series by two fields

    It works,

    Thank you a lot,

    Jose G Diaz

  • Verified answer
    Wahaj Rashid Profile Picture
    Wahaj Rashid 11,321 on at
    RE: Group chart in Legend series by two fields

    Hi,

    Thank you for your query.

    Can you please try switching legends and Horizontal categories (as per the following):

    • Legend:
      • GrossWt (Sum)
    • Horizontal (Category) Axis Label:
      • FlightDate (Day)
      • Agent

    Example from my environment:

    pastedimage1612906425856v1.png

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

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
DAnny3211 Profile Picture

DAnny3211 433

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 137 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 67 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Identifying an Org as CDS or Dynamics
Get batch job history log from D365 FO to Power Automate
Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans