web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Pie chart not showing

Power Apps

Answered

Pie chart not showing

(0) Share

Report

Report

Posted on by ReyOrtiz

146

Hi Everyone

I hope all is well.

I need some guidance regarding Pie Charts. I am trying to set one based on a SharePoint tracker list, and when I dd the criteria the pie won’t show. This is the formula I used.

Distinct(Filter(CETroubleshooting_tracker,Territory=ComboBox8.Selected.Result),Category)

and here is a screenshot

Thank you for the help

Best Regards
Rey O

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @ReyOrtiz,

Let me confirm something with you, Category is a single-line-of-text column type, right?

Based on this, I think there is something important you should know about the Pie Chart:

1). There must be a column to store the percentage of each item out of the total number of items in the column

2). If there is not, you should add a temporary column to sum the total of each item

3). Use GroupBy() instead of Distinct().

Here is a demo for your reference:

In your scenario, you should modify your formula as below:

AddColumns(GroupBy(Filter(CETroubleshooting_tracker,Territory=ComboBox8.Selected.Result),"Category","CategoryG"),"Qty",CountRows(CategoryG))
ReyOrtiz 146 on at

Like
a
(0)

Report
Copy link

Link copied!

thank ou so much it worked perfectly thank you again

Join the conversation