cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Pie chart from excel table

Hi everyone, i have searched to the best of my knowledge, but i can't seem to find the right method.

 

I have an excel sheet to monitor log ins.  More importantly, if it was an incorrect password.

 

My table called "AuditLog" has

3 columns:

  • Name
  • successful
  • failed

 

I would like a pie chart to pull the data from an excel sheet (thats already a connection) and just give me a visual representation of how many successful vs failed log in attempts.

 

Any help, would be super.


Thanks,

Joe.

2 REPLIES 2
Highlighted
Helper I
Helper I

Re: Pie chart from excel table

I learned how to use pie charts from this video:

https://youtu.be/22HqqVp-I80

 

You would want to group by Name, Successful, and Failed and then sum those groups.
Below is the code that i used and worked well for me. 

AddColumns(GroupBy(DataSource, "ColumnName", "group"),"SumOfCategory", Coalesce(Sum(group,cost)))
Highlighted
Super User
Super User

Re: Pie chart from excel table

Take a look at the following articles:  

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/use-line-pie-bar-chart

and 

https://powerusers.microsoft.com/t5/General-Discussion/Help-showing-percentage-pie-chart-from-yes-no...  

 

The second article is based on a Sharepoint list, but the concept is the same - your data source will just be different.

 

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,233)