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 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)
  • 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

  • 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

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 365 | Integration, Dataverse, and general topics

#1
#ManoVerse Profile Picture

#ManoVerse 101

#2
Siv Sagar Profile Picture

Siv Sagar 93 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 66 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