Graph with SharePoint list

[Anonymous]

Hello;

I have a PowerApps application and I would like to make a Power Bi graph in this application.

In my application I have a SharePoint list containing homeworking requests by user.

In my application, the user can only see his requests because I have a condition that test on the name of the user and the account with which he is connected. ==> Property Visible => [IF Requester.Email = User().Email;]

I would like to have graph by user that when he clicks a button he obtains this graph : 

A graph wih on one axis the number of "homeworking days"/month and on the other axis (the months of the year) ?

The Status for the request must be approved to add day on graph (chart bars)

For exemple : Result for Person "XYZ" => 4 days on April, 3 days on September,... 

1) How is it possible to make this graph ? Send list information with Power Flows to Power Bi ?

2) How with the information is it possible to realize this graph ?

The List SharePoint  : 

Thanks for your help ! 🙂

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

You could get data with SharePoint list from "Get Data".

Then create a new column.

Month =
MONTH ( 'Table'[Your date column] )

Then you can use stacked column/bar chart to get the visual. Use Month column as an x-axis and use count of Month as an y-axis.

For example:

You could add a slicer to select different peaple.