web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Chart questions

Power Apps

Answered

Chart questions

(0) Share

Report

Report

Posted on by fiddlerx

103

Hi team,

I have added an Excel Online file to my new Canvas app

Excel file has a table called "Table1"

It has two columns. "Country" and "Office"

I would like to create a Pie chart to display how many offices there are in each country.

If I just add the pie I can see all countries or offices not not grouped with a number?

Second question:

Can I somehow group a query to get the number of offices in total and being displayed in a regular text filed in the app?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @fiddlerx ,

Please try:

AddColumns(GroupBy(TableName,"Country","NewColumn"),"CountOffice",CountRows(NewColumn))

Best Regards,

Bof

Was this reply helpful? Yes No
fiddlerx 103 on at

Like
a
(0)

Report
Copy link

Link copied!

Perfect and If I would like to select 3 countries and exclude the rest can that be done in the same function?

Was this reply helpful? Yes No

Join the conversation