cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
perplexedDev Frequent Visitor
Frequent Visitor

Flexible line chart x-axis

I have a table

Date    FullName     Name    Avg

4/11     AB                A           3.2

4/11     AC               A           1.2

4/12     DE                D           4.3

4/12     EF                E            2.6

4/12     FG               F             8.5

 

I want to plot this on a line chart with Y axis as Avg, and X-Axis as Date. I want to plot all the values for a date, when I tried this it shows the option for Sum,Average,Minimum etc instead of having the option to plot all the points in each date.

 

I would also like to show the name and full name for each point on the chart, is it possible to show it on the x-axis grouping by Date as below
chartsample.png

 

Is it also possible to have 2 reference lines. I can see the option to add one reference line. This is indicate if the average has goone above or below a certain point.

2 REPLIES 2
Sean Super Contributor
Super Contributor

Re: Flexible line chart x-axis

Chart - Test.png

Is this what you are trying to achieve?

Which field asked you for Sum, Avg, etc...?

 

Highlighted
perplexedDev Frequent Visitor
Frequent Visitor

Re: Flexible line chart x-axis

The dates you have on x-axis have different times, 12 AM and 6:00 AM. Mine are the same dates 11/4 12:00 AM with different values. This asked for sum/Average/Mean etc

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 155 members 2,153 guests
Please welcome our newest community members: