Unanswered

Bar Graph from Sharepoint for two columns and sum of total.

(1) Share

Report

Posted on by Community Power Pla...

I have a sharepoint list called 'Expense' with ~20 columns. Among them i am trying to create a bar graph using "Category" and "Total Amount"..

i need to group "Category" like bills, travel... etc

Sum of group of category....

in a bar graph...

I tried multiple solutions here in community but failed... Can someone help please
Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

JesperHuang 56 on at

Like (1)

Report
Hi @Anonymous ,

Is this what you want?

Here is the code i put in Onselect event：
ClearCollect( Expense, { Category: "Learn", Price: 8615000}, { Category: "Bills", Price: 3562000}, { Category: "Travel", Price: 3165000}, { Category: "Books", Price: 2874000}, { Category: "Learn", Price: 2273000}, { Category: "Bills", Price: 1760000}, { Category: "Travel", Price: 1602000}, { Category: "Bills", Price: 1494000}, { Category: "Books", Price: 1344000} ); ClearCollect(GroupExpense, GroupBy(Expense,"Category","Prices")); ClearCollect(SumByCate, AddColumns(GroupExpense, "Total Amount", Sum(Prices,Price)));

Was this reply helpful? Yes No
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

Hey @Anonymous

Can you try to use the below expression on the Items property of your graph?

AddColumns(GroupBy(SPListName,"Category","Grouped"),"TotalCount", Sum(Grouped, TotalAmount))

Then, you can use Category and TotalCount in the graph series and labels.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

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

Like (0)

Report

But i do not want to define the category in Powerapps since its going to be a dynamic values... Some categories will be added later in the stage. how to do without defining categories manually in powerapps?

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

Like (0)

Report

Thank you so much... this perfectly worked 🙂
I am so glad to learn how to make bar graph now.

Was this reply helpful? Yes No