Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hi!!
I am trying to build a gnatt based on this table below. I want it to look similar to this photo but I need symbols on the rows for the 'Out and In Dates" but want to keep the bar I already have.
I tried added the 'In and out' date columns to milestones and this didn't work.
Please note I can't attach real data as it is senstive.
Any help??
Client | Project ID | Milestone | Target Date | Projected Date | Actual Date | Projected Dt if blank Target Dt | Live Start | Lock Start | In Proj Dt if blank Target Dt | Out Proj Dt if blank Target Dt | start date |
Client 1 | Project 1 | Lock | 19-Jan-24 | 16-Apr-24 | 16-Apr-24 | 17-Mar-24 | 17-Mar-24 | ||||
Client 1 | Project 1 | Out | 29-Sep-23 | 27-Dec-23 | 27-Dec-23 | 27-Dec-23 | |||||
Client 1 | Project 1 | In | 6-Dec-21 | 6-Dec-21 | 6-Dec-21 | ||||||
Client 1 | Project 1 | Live | 22-Nov-21 | 1-Dec-21 | 1-Dec-21 | 18-Aug-21 | 18-Aug-21 | ||||
Client 2 | Project 2 | Out | 18-Jul-24 | 25-Nov-25 | 25-Nov-25 | 25-Nov-25 | |||||
Client 2 | Project 2 | In | 15-Aug-19 | 16-Sep-19 | 16-Sep-19 | 16-Sep-19 | 16-Sep-19 | ||||
Client 2 | Project 2 | Live | 6-Aug-19 | 13-Aug-19 | 13-Aug-19 | 13-Aug-19 | 30-Apr-19 | 30-Apr-19 | |||
Client 2 | Project 2 | Lock | 20-Aug-24 | 22-Dec-25 | 22-Dec-25 | 23-Nov-25 | 23-Nov-25 | ||||
Client 2 | Project 2 | Out | 2-Oct-24 | 19-Feb-26 | 19-Feb-26 |
Hi @jen8080 ,
“I need symbols on the rows for the 'Out and In Dates"
I'm not quite sure if I understand your needs accurately,Could you please explain more about this need?
Hope it helps,
Community Support Team _ Caitlyn
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
| User | Count |
|---|---|
| 22 | |
| 20 | |
| 19 | |
| 19 | |
| 11 |
| User | Count |
|---|---|
| 61 | |
| 54 | |
| 46 | |
| 44 | |
| 34 |