Gantt Chart to show Years and Quarters

[kamini]

Hi and good morning,

I have to develop a Gantt Chart that shows the year and quarters based on the following specifications,😀

Project	Start Date	End Date	Duration	Status
Project 1	1/1/2022	5/1/2022	120	Completed
Project 2	5/5/2022	12/1/2022	210	Pending
Project 3	12/5/2022	5/10/2023	156	Pending
Project 4	5/11/2023	12/1/2023	204	Pending

I have see many Gantt Charts showing years and months but looking for a way to create the Gantt chart that shows Year on top and Quarter under the years. 

This Gantt Chart will need to be customized for Bar size and colors and other important features.

I really appreciate your help on this.

Thank you,

[GrowthNatives · Accepted solution]

Hi  @Lipa , I understand you are facing an issue with creating line chart where latest build will be displayed black color always. To create a Gantt Chart in Power BI that displays Years on top and Quarters under each year

 ✅ Step 1: Load Data into Power BI

Ensure that Start Date and End Date columns are in Date format (you may need to clean/transform the data in Power Query).

✅ Step 2: Create Date Table

Create a Date Table with Year & Quarter columns:

Use DAX:

DateTable = 
ADDCOLUMNS (
    CALENDAR (MIN(Projects[Start Date]), MAX(Projects[End Date])),
    "Year", YEAR([Date]),
    "Quarter", "Q" & FORMAT(QUARTER([Date]), "0")
)

Relate your Projects[Start Date] to DateTable[Date].

In visuals or slicers, use the DateTable[Year] and DateTable[Quarter] fields for filters or display.

✅ Step 3: Create a Gantt Chart Visual

• Go to Visualizations pane > ... (Get more visuals).
• Search for "Gantt".
• Choose “Gantt Chart by MAQ Software” or “Gantt Chart by Microsoft”.
  
  

✅ Step 4: Configure the Gantt Chart

Drag these fields:

• Task → Project
• Start Date → Start Date
• End Date or Duration → use End Date if available
• Legend or Color → Status
• Tooltips → Add Duration, Status, StartYear, etc.

✅ Step 5: Customize Bar Size & Color

In the Gantt visual formatting options:

Go to Bar formatting:

Change bar thickness or height.

Set color by Status:

• Completed → Green or Blue
• Pending → Orange or Red

Enable Data Labels if needed.

Turn on Gridlines, Milestones, etc., as needed.


⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together! 🚀

[kamini]

Thanks so much Lipa. I greatly appreciate it and I'll be working on this shortly. Kamran

[Akash_Varuna]

Hi @kamini  For this, you will need to use a custom Gantt chart visual like Gantt by MAQ Software. Create calculated columns for Year and Quarter, or combine them into one (Year & " Q" & Quarter) for the axis. Customize the bar sizes and colors dynamically using DAX measures based on status.

[kamini]

Thank you for your recommendation. I'll proceed. Since I'm not an expert or novice users in Power BI, would it be possible if you share a sample .pbix with me using this MAQ plugin?