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:

General Questions

All responses (9)

Answers (1)

Verified answer

v-jefferni on at

Like (1)

Report

Re: how to create column chart from SP list

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,
venky232 on at

Like (0)

Report

Re: how to create column chart from SP list

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

Like (0)

Report
Re: how to create column chart from SP list

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,
venky232 on at

Like (0)

Report

Re: how to create column chart from SP list

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.
v-jefferni on at

Like (0)

Report

Re: how to create column chart from SP list

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,
venky232 on at

Like (0)

Report

Re: how to create column chart from SP list

it repeating same value in chart
v-jefferni on at

Like (0)

Report

Re: how to create column chart from SP list

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,
venky232 on at

Like (0)

Report

Re: how to create column chart from SP list

its not working if i add distinct

Clearcollect(Coll,AddColumns(Distinct(SPList, "Person1", ThisRecord.PersonColumn.DisplayName, ThisRecord.PersonColumn1.DisplayName,"Person2"))
v-jefferni on at

Like (0)

Report
Re: how to create column chart from SP list

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,