cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rahmanig
New Member

Graph Charts

Hi all, 

 

I have the challenge to present the below data in Powerapps chart and hope you can help me:

 

The data: 

 

IDFiscal QuarterProduct Sellout
21W-44FY16-Q4Networking$216
905LFY17-Q2Compute$538
906PFY16-Q3Compute$134
CSN-22FY16-Q3Compute$1,760
CSN-22FY16-Q3Services$445
CSN-22FY16-Q4Compute$1,389
CSN-22FY17-Q1Compute$9,355
CSN-22FY17-Q1Storage$9,524
CSN-22FY17-Q2Compute$890
DLQFFY16-Q3Compute$6,970
DLQFFY16-Q3Networking$1,602
DLQFFY16-Q3Services$775
DLQFFY16-Q4Compute$6,517
DLQFFY16-Q4Storage$7,754
DLQFFY16-Q4Networking$6,987
DLQFFY17-Q1Compute$2,073
DLQFFY17-Q1Services$163
DLQFFY17-Q2Compute$381
DLQFFY17-Q2Networking$212
DLQFFY17-Q2Services$109
DLQFFY17-Q3Compute$4,562
P9D-156FY16-Q3Networking$491
P9D-156FY16-Q4Networking$263
P9D-156FY17-Q1Networking$1,110
P9D-4FY16-Q3Compute$2,154

 

What I want to achieve i.e:

 

Capture.PNG

 

 

Issues: 

 

I have a column of ID which represent customers. each customer has multiple records and my quarter data should be shown in columns rather than a column. So firstly I am not sure how to order the data in a format that PowerApps need: i.e.

 

Customer: 905L

Products Q1Q2Q3Q4
Server££££££££
Storage££££££££
Networking ££££££££

 

and second is that I am not sure how to have all the data in one table and use a filter in Powrapps to show the chart!

 

Any help is appreciated.

 

Thanks

Ghasem

2 REPLIES 2
v-monli-msft
Community Support
Community Support

Hi @rahmanig,

 

I think your data does not fit in PowerApps to show in a line chart maybe. I suggest that you could try to rearrange the data something similar to the sample data in below link:

https://powerapps.microsoft.com/en-us/tutorials/use-line-pie-bar-chart/

 

Capture.PNG

 

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks @v-monli-msft 

 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,032)