web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Bar Graph - group data

Power Apps

Unanswered

Bar Graph - group data

(0) Share

Report

Report

Posted on by AmeliaDwight

92

Hi,

I have a table that has

3 columns - Market, Shop, Spend where each Market can have multiple shops and vise versa

eg

UK, Tesco, 500

Germany, Tesco, 100

Uk, Aldi, 300

France, Tesco, 5000

i want to create a graph that has Market on the X-Axis and Total Spend on the Y

right now, its repeating markets and not grouping them together - how do i change this?

eg i have a graph with Uk, Uk, France, Germany, Germany...

and i want Uk, France, Germany

Thanks!!

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

Geeks_D 1,169 on at

Like
a
(0)

Report
Copy link

Link copied!
ClearCollect( Data, { Market: "UK", Shop: "Tesco", Spend: "500" }, { Market: "Germany", Shop: "Tesco", Spend: "100" }, { Market: "France", Shop: "Aldi", Spend: "300" }, { Market: "France", Shop: "Tesco", Spend: "5000" } ); ClearCollect( Graphdata, Distinct( Data, Market ) ); ForAll( Graphdata, Collect( Graph, { Market: Value, TotalSpend: Sum( Filter( Data, Market = Value ), Spend ) } ) )
AmeliaDwight 92 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Geeks_D

Is there a way to do this without writing it out as my table is going to have data added to it by the user?
Geeks_D 1,169 on at

Like
a
(0)

Report
Copy link

Link copied!

You can use a Clear and Collect to do this based on the user data and filters

Join the conversation