Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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/
@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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
139 | |
100 | |
95 | |
85 | |
63 |