how to create column chart from SP list

(0) Share

Report

Posted on by venky232

i have sharepoint with 30 columns, some column contains people/group where user details avaible.

when i try to connect List to column chart Data: it is not displaying some column in Labels, Series1,2,3,4...

how to get the remaining coloumn there?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

v-jefferni on at

Like (0)

Report
Hi @venky232 ,

Could you please share more details about your scenario? What columns would you like to display as series in a Column Chart?

If you would like to use special columns as series, please try and use the AddColumns function to reinforce the table structure, then use these custom columns as chart series:

AddColumns(SPList, "Person1", ThisRecord.PersonColumn.DisplayName, "Person1", ThisRecord.PersonColumn1.DisplayName,"Person2", ThisRecord.PersonColumn2.DisplayName,"Person3", ThisRecord.PersonColumn3.DisplayName)

Best regards,

Was this reply helpful? Yes No
venky232 on at

Like (0)

Report

its not working if i add distinct

Clearcollect(Coll,AddColumns(Distinct(SPList, "Person1", ThisRecord.PersonColumn.DisplayName, ThisRecord.PersonColumn1.DisplayName,"Person2"))

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @venky232 ,

Distinct function returns a single column table, so I don't think it should be used for creating the data of a chart.

Best regards,

Was this reply helpful? Yes No
venky232 on at

Like (0)

Report

it repeating same value in chart

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @venky232 ,

Could you please share any sample data to describe your list data source? For multiple series column chart, same values are common.

Below is a blog about creating column chart in PowerApps, for your reference:

PowerApps charts (Column, Line and Pie Chart) - SPGuides

Best regards,

Was this reply helpful? Yes No
venky232 on at

Like (0)

Report

i have 2 columns
column1 : Employees (100 Employees) & Column2:Manager( contains 10 managers)
i plotted column chart ,where in X i kept manager ,so it is showing same manager name repeatedly.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report
Hi @venky232 ,

Column Chart is used for displaying the numbers of each column, so what effect do you want to express with a column chart? Is it how many employees is each manager responsible for? If so, you will need to count the employees that takeover by each manager. Please try below formula in Items of the chart:

AddColumns(GroupBy(AddColumns(SPList, "manager", ThisRecord.Manager.DisplayName),"manager","EmployeesEach"),"EmployeeSum",CountRows(ThisRecord.EmployeesEach)

X-axis set to the custom "manger" column and the chart will show the number of employees that each manager responsible for.

Best regards,

Was this reply helpful? Yes No
venky232 on at

Like (0)

Report

this code is working ,but i want to add one more additional column which is choice column (Company).
how to do this?

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (1)

Report

Hi @venky232 ,

It depends on the data structure. Basically, you can add a column like the person column and use it to count how many employees each company includes. However, the two scenarios (group by companies or managers) cannot be implemented in a single column chart. You must understand how a column chart works, and this is why I recommended you read the blog, especially need to understand the list structure:

Best regards,

Was this reply helpful? Yes No