Announcements
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?
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,
its not working if i add distinct
Clearcollect(Coll,AddColumns(Distinct(SPList, "Person1", ThisRecord.PersonColumn.DisplayName, ThisRecord.PersonColumn1.DisplayName,"Person2"))
Distinct function returns a single column table, so I don't think it should be used for creating the data of a chart.
it repeating same value in chart
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
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.
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.
this code is working ,but i want to add one more additional column which is choice column (Company).
how to do this?
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:
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 352 Most Valuable Professional
11manish 192
Valantis 128
