cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Charts

Hello!!

 

I have a column with the answers yes or no in it.

 

How can I build a graph to give me the  # of times Yes or No are displayed in the column?

 

For example - Yes = 23 , No = 45.

 

Thank you!

3 REPLIES 3
Community Support Team
Community Support Team

Re: Charts

Hi Lp939,

 

Are you using a SharePoint list as your data source? What is the column type? Is it a Text column or a Yes/No(check box) column?

 

As a workaround, I use a TextBox control instead of a Chart control. I have a Yes/No(check box) column in my SharePoint list. In the App, I use a CountIf function to get the number of Yes/No in the list. I add a TexBox on the App and set its Text property to: CountIf(DataSource,Yes/No=true). Then I would get the number of “Yes” in my list.

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Power Apps Staff rgruian
Power Apps Staff

Re: Charts

 

What kind of graph/chart do you need to show?

 

Assuming that you need a pie chart, and assuming that your data source name is "MyData" and the column name is "Answer", you can do this:

 

    PieChart1.Items = AddColumns(GroupBy(MyData, "Answer", "Group"), "Count", CountRows(Group))

        Labels = Answer

        Series = Count

 

I hope this helps.

 

 

Radu Gruian [MSFT] ** PowerApps Staff
starwispy
Level: Powered On

Re: Charts

So glad for this post - my pie chart is finally displaying data!  Thank you @rgruian 🙂

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (6,277)