Graph Charts

[rahmanig]

Hi all, 

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

The data: 

ID	Fiscal Quarter	Product	Sellout
21W-44	FY16-Q4	Networking	$216
905L	FY17-Q2	Compute	$538
906P	FY16-Q3	Compute	$134
CSN-22	FY16-Q3	Compute	$1,760
CSN-22	FY16-Q3	Services	$445
CSN-22	FY16-Q4	Compute	$1,389
CSN-22	FY17-Q1	Compute	$9,355
CSN-22	FY17-Q1	Storage	$9,524
CSN-22	FY17-Q2	Compute	$890
DLQF	FY16-Q3	Compute	$6,970
DLQF	FY16-Q3	Networking	$1,602
DLQF	FY16-Q3	Services	$775
DLQF	FY16-Q4	Compute	$6,517
DLQF	FY16-Q4	Storage	$7,754
DLQF	FY16-Q4	Networking	$6,987
DLQF	FY17-Q1	Compute	$2,073
DLQF	FY17-Q1	Services	$163
DLQF	FY17-Q2	Compute	$381
DLQF	FY17-Q2	Networking	$212
DLQF	FY17-Q2	Services	$109
DLQF	FY17-Q3	Compute	$4,562
P9D-156	FY16-Q3	Networking	$491
P9D-156	FY16-Q4	Networking	$263
P9D-156	FY17-Q1	Networking	$1,110
P9D-4	FY16-Q3	Compute	$2,154

What I want to achieve i.e:

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	Q1	Q2	Q3	Q4
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

[v-monli-msft]

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/

Regards,

Mona

[rahmanig]

Thanks @v-monli-msft 

I did look at that before which means I have to create a table for each customer and that is not ideal! there must be another way of doing this!

Regards 

Ghasem