Column Chart 2 Column

(0) Share

Report

Posted on by firda59

372

Hello,

I'm new in using column chart. So, I have this data:

I want to make chart like this:

But I dont know how to add formula in this chart, and now I'm using formula like this:
AddColumns(GroupBy(AddColumns('PERGERAKAN KOMPONEN',"abc",'Next Location'),"abc","abcCount"),"Total Komponen", CountRows(abcCount))

Can anyone help me? Thank you.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

v-hanytian-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @firda59 ,

We Made a sample for you.
DataSource:

Insert a Button for Collection the data:
ClearCollect(Col1, AddColumns(GroupBy(AddColumns('0802-2',"abc",'Next Location'),"abc","abcCount"),"Total Komponen", CountRows(abcCount)),{Test:0});
ClearCollect(Col2,AddColumns(GroupBy(AddColumns('0802-2',"abc",'Current Location'.Value),"abc","abcCount"),"Test", CountRows(abcCount)));
ForAll(Col2 As C,If(C.abc in Col1.abc,Patch(Col1,LookUp(Col1,abc = C.abc),{Test:C.Test}),Patch(Col1,Defaults(Col1),{abc:C.abc,Test:C.Test})))

Items:Col1

NumberOfSeries:2

Hope this will help you,

Best Regards,
Tina
firda59 372 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @v-hanytian-msft

Patch(Col1,LookUp(Col1,abc = C.abc),{Test:C.Test}),Patch(Col1,Defaults(Col1),{abc:C.abc,Test:C.Test})))

may I know what the meaning of C.abc? Cause I got error message,
v-hanytian-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @firda59 ,
C.abc mens it can get the field of Col2,

Operators and Identifiers in Power Apps - Power Platform | Microsoft Learn

May I ask what are the formula you wrote of the OnSelect?
We can fix it together.

Hope this will help you,
Best Regards,
Tina
firda59 372 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @v-hanytian-msft

ClearCollect(Col1, AddColumns(GroupBy(AddColumns('PERGERAKAN KOMPONEN',"abc",'Next Location'),"abc","abcCount"),"Next Loc.", CountRows(abcCount)),{Test:0});
ClearCollect(Col2,AddColumns(GroupBy(AddColumns('PERGERAKAN KOMPONEN',"abc",'Current Location'),"abc","abcCount"),"Current Loc.", CountRows(abcCount)));
ForAll(Col2 As C,If(C.abc in Col1.abc, Patch(Col1,LookUp(Col1,abc = C.abc),{Test:C.Test}),Patch(Col1,Defaults(Col1),{abc:C.abc,Test:C.Test})))

This is my formula, and the error:
I also got this error: The function 'Patch' has some invalid arguments.
Verified answer

v-hanytian-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @firda59 ,
Thank you for such detailed information.

Please try this:
ClearCollect(Col1, AddColumns(GroupBy(AddColumns('PERGERAKAN KOMPONEN',"abc",'Next Location'),"abc","abcCount"),"Next Loc.", CountRows(abcCount)),{'Current Loc.':0}); ClearCollect(Col2,AddColumns(GroupBy(AddColumns('PERGERAKAN KOMPONEN',"abc",'Current Location'.Value),"abc","abcCount"),"Current Loc.", CountRows(abcCount))); ForAll(Col2 As C,If(C.abc in Col1.abc, Patch(Col1,LookUp(Col1,abc = C.abc),{'Current Loc.':C.'Current Loc.'}),Patch(Col1,Defaults(Col1),{abc:C.abc,'Current Loc.':C.'Current Loc.'})))
Hope this will help you,
Best Regards,
Tina
firda59 372 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @v-hanytian-msft

Thankyou so much!