Can a build a column chart which show 2 columns for each user

(0) Share

Report

Posted on by johnjohn123

3,514

I have the following sharepoint list:-

as shown it show an engineer name and the number of green and red points each engineer got.

so i want to build canvas inside power app which shows a column chart >> where the column chart should show 2 columns (Green & Red) for each engineer? is this possible.

Now i created a new canvas >> add a column chart >> define the following:-

But it did not work, where i am unable to show 2 columns for each user + i am unable to find the Engineer field which is of type People or Group that allow single selection.

what i am looking for is something as follow:-

Regards

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

rubin_boer 4,843 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

hi @johnjohn123

add a chart control and add tis to its Items = AddColumns(GroupBy(YourData,"Engineer","User"),"Total Red",Sum(User,Red),"Total Green",Sum(User,Green))

St Number of series = 2

This is what you will get.

Hope it helps

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@rubin_boerthanks for the reply. i tried you approach but i got an error that GroupBy has some invalid arguments, as follow:-

Hint:- the Engineer field has an internal name =ScoreUser

I also tried this formula, but i got more errors on the GroupBy and on the Sum:-

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@johnjohn123 Why do you need to use Group by?

What you need to do is change the number of series to 2.
Go to Properties-> Number of series = 2
Also, change the colour of the series using ItemColorSet in the Advanced section:

I did Red, Green because of the table I used. You might want to do the reverse for your case.

If you want to use Group by for some reason, you might have to work with the formula a little, but you need to use it in case your Engineer column has repeated values.

Please accept the solution if it helps you!

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@Anonymousi changed the number of series to 2 .. but which formula i need to use?

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

@johnjohn123 Do you require Grouping?

You would require grouping if your data looks like this:
Engineer Red Points Green Points
John 2 3
John 4 2
Himanshu 1 6
S 3 5
S 2 2
Sharma 2 5
Sharma 1 1
Sharma 1 2
(repeating engineers)
You do not need to group if your data looks like this:
Engineer Red Points Green Points
John 2 3
John 123 4 2
Himanshu 1 6
S 3 5
Sharma 2 5

If your data is like the second one, use AddColumns(Scores, "UserName", Engineer.FullName)

If your data is like the second one, use AddColumns(GroupBy(Scores, "Engineer", "Data"), "UserName", Engineer.FullName, "Red Points", Sum(Data, ScoreRedPoint), "Green Points", Sum(Data, ScoreGreenPoint))

I am assuming Engineer.FullName is the name field in your organisation. I am assuming the case where your engineer columns is linked to people in your organisation.

In case Engineer is a simple string field, you do not need to use Engineer.FullName. Skip the part and you are good.

Was this reply helpful? Yes No