web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Column chart on number...

Power Apps

Answered

Column chart on number and choice column

(0) Share

Report

Report

Posted on by Puuskis

Hi,

I’m new with Power apps and I would like to ask help with a basic functionality on column charts.

I’m trying to create a column chart that includes teams names and then a number column. I couldn’t figure out how to do it. My goal is to create a chart that shows easily how many phone calls each team has done.

SP columns

- date (date field)

- Team name (choice)

- number of calls (Number field)

Thanks in advance! 🙂

/Puuskis

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Puuskis ,

I did a test for you .

1\ This is my list 'LIST124'.

2\ Add a column chart and set its Items property to:

AddColumns(GroupBy(AddColumns(LIST124,"TeamName2",TeamName.Value),"TeamName2","AfterGroup"),"Number",Sum(ThisRecord.AfterGroup,NumberOfCalls))

3\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.
nmlsanmiguel on at

Like
a
(0)

Report
Copy link

Link copied!

Sir what's the "AfterGroup"? is it a new column?

Join the conversation