Graph per Person list sharepoint

Hey,

 

to achieve what you want I would do this:

1. Make suere that the  "Date_For_..." column is of data type Date
2. Create an additional calculated column that extracts the year from the date column using a DAX statement like this
   

   Year = YEAR('<tablename>'[Date_From_...])

3. Create an additional calculated column that exctract the month (numeric) from the date column using a DAX statement like this
   

   Month = Month('<tablename>'[Date_From_...])

4. Create an additional calculated column that exctract the month name from the date column using a DAX statement like this
   

   Month Name = FORMAT('<tablename>'[Date_From_...] , "MMM")

5.  Make sure that the column "Month Name" is sorted by the column "Month"
   https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-button

Now you can create a column chart, using the newly created column "Month Name" on the x-axis, drag the "Date_From_..." column to the value band and switch the aggregation function to count.

 

Use the column "Requester" as a slicer to make sure that only the values from one person are used.

 

If you want to create a chart that contains all the data for all persons at the same time, but in an extra chart, you have to use a custom visual that supports "small multiples" like the Infographic Designer (available from the marketplace without any costs). Here is a screenshot of a small multiple created by using the Infograhic Designer custom visual:

Hopefully this provides you with some ideas.

 

Regards,

Tom