I'm building a dashboard to show absenteeism data. I am attempting to show trends of absenteeism over the months with a line graph similar to the one I build in Excel (below).
At the moment our absenteeism data is set up as below. When I attempt a line graph it is empty or plotted vertically.
| Division | Bus Unit | Leave From | Leave To | Hours Absent | Days Absent | 1/07/2023 | 1/08/2023 | 1/09/2023 | 1/10/2023 | 1/11/2023 | 1/12/2023 | 1/01/2024 | 1/02/2024 | 1/03/2024 | 1/04/2024 | 1/05/2024 | 1/06/2024 | Year to date leave |
| Public Works | Building Services | 20/07/2023 | 20/07/2023 | 3 | 0.41 | 0.41 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.41 | ||||||
| Public Works | Building Services | 28/07/2023 | 13/09/2023 | 246.5 | 34 | 3.89 | 20.40 | 9.71 | 0.00 | 0.00 | 0.00 | 34.00 | ||||||
| Public Works | Major Projects | 22/06/2023 | 20/07/2023 | 152.25 | 21 | 14.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 14.00 | ||||||
| Corporate & Portfolio Strategy | Legal Services | 5/12/2023 | 11/12/2023 | 36.25 | 5 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5.00 | 5.00 | ||||||
| Corporate & Portfolio Strategy | Technology & Digital Solutions | 6/11/2023 | 10/11/2023 | 36.25 | 5 | 0.00 | 0.00 | 0.00 | 0.00 | 5.00 | 0.00 | 5.00 | ||||||
| Public Works | Major Projects | 21/08/2023 | 25/08/2023 | 36.25 | 5 | 0.00 | 5.00 | 0.00 | 0.00 | 0.00 | 0.00 | 5.00 | ||||||
| Public Works | Major Projects | 28/11/2023 | 1/12/2023 | 29 | 4 | 0.00 | 0.00 | 0.00 | 0.00 | 3.00 | 1.00 | 4.00 | ||||||
| Energy | Supply and Storage | 25/10/2023 | 27/10/2023 | 21.75 | 3 | 0.00 | 0.00 | 0.00 | 3.00 | 0.00 | 0.00 | 3.00 | ||||||
| Procurement | Procurement Policy | 11/07/2023 | 13/07/2023 | 21.75 | 3 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 3.00 | ||||||
| Hydrogen and Future Fuels | 14/12/2023 | 15/12/2023 | 14.5 | 2 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 2.00 | |||||||
| Corporate & Portfolio Strategy | Portfolio Strategy | 4/12/2023 | 5/12/2023 | 14.5 | 2 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 2.00 | ||||||
| Energy | Distribution Consumer and Innovation | 13/11/2023 | 14/11/2023 | 14.5 | 2 | 0.00 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 2.00 | ||||||
| Public Works | Building Services | 13/09/2023 | 16/09/2023 | 14.5 | 2 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 0.00 | 2.00 | ||||||
| Procurement | General Goods & Services | 10/10/2023 | 11/10/2023 | 14.5 | 2 | 0.00 | 0.00 | 0.00 | 2.00 | 0.00 | 0.00 | 2.00 |
Hi @VirginiaL ,
You seem to need to process the data, consolidate all the date columns, do the unpivot column. then put in the fields as shown
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @VirginiaL ,
You seem to need to process the data, consolidate all the date columns, do the unpivot column. then put in the fields as shown
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Helpful resources
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
