Pie chart from excel table

[Joko]

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.

[Anonymous]

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)))

[LRVinNC]

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.