Answered

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

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

All responses (4)

Answers (1)

Sort by

JesperHuang 56 on at

Like
a
(1)

Report
Copy link

Link copied!
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)));
Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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