Help Representing Dates in a Line Graph

[Anonymous]

Hi all,

Thanks for help in advance I have spent the past hour trying to work what to do but would like your help. I am trying to represent the working status of employees and would like to present the data across the time with each function representing a line if that makes sense.  

I currently have a data set that looks like this:

Name	Function	19/09/2020	29/09/2020
Stefan Bloggs	Finance	Working	Reduced Hours
Flossy Chat	Human Resources	Reduced Hours	Working
Peter Pan	Finance	Reduced Hours	Reduced Hours
Iron Man	Human Resources	Working	Working

etc...

Do I need to transform any of the data so I am able to represent it in a line graph? I would like the line graph across the X axis to represent date, the Y axis to represent how many, and the line (different coloured lines for each group) to either represent the functional area (HR, Finance) or the status of the employee (reduced hours/working). How would you represent this?Your help is greatly appreciated.

[amitchandak · Accepted solution]

@Anonymous , Can you share sample output in table format

You need to unpivot this data first

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/