Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
JDonnellan
Regular Visitor

Help with chart for an Employee Leave Viewer

Chart for an Employee Leave Viewer 5 seconds ago Hi everyone, I am wondering how can I create a chart (assuming Gantt chart) that will resemble and work like this employee leave day viewer chart (I have attached) as close as possible and its properties in PowerBI. The red represents the days the employees were absent due to holidays, remote work, ect. The names would be under the name column and where the black is covering.

 

I know you can import Gantt chart visuals but I am wondering which one would suit this task best and how I would format so it behaves as close to this as possible:

1.PNG

 

 

I have included the data I have for the report:

2.PNG

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Your solution is so great bhanu_gautam 

Hi, @JDonnellan 

Based on your description, here's an example PBIX file:

vjianpengmsft_0-1738741367295.png

vjianpengmsft_1-1738741379264.png

vjianpengmsft_2-1738741394514.png

vjianpengmsft_4-1738741412074.png

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Your solution is so great bhanu_gautam 

Hi, @JDonnellan 

Based on your description, here's an example PBIX file:

vjianpengmsft_0-1738741367295.png

vjianpengmsft_1-1738741379264.png

vjianpengmsft_2-1738741394514.png

vjianpengmsft_4-1738741412074.png

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

bhanu_gautam
Super User
Super User

@JDonnellan , Go through this

https://community.fabric.microsoft.com/t5/Desktop/Createing-a-gantt-chart-with-matrix-visualization/...

 

And this 

https://community.fabric.microsoft.com/t5/Desktop/Help-on-chart/m-p/4394012#M1369276




Did I answer your question? Mark my post as a solution! And Kudos are appreciated

Proud to be a Super User!




LinkedIn






Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.