Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Level up your Power BI skills this month - build one visual each week and tell better stories with data! Get started

Reply
AppleBoy
Frequent Visitor

Need Month-Year Granularity in Free Gantt Visual for Power BI

‎12-01-2025 01:03 AM

Hi Team,
I’m working on a project timeline visualization in Power BI. My goal is to show projects across months (MMM-YYYY) with managers clearly visible.

Current challenges:

  • The Microsoft Gantt visual only supports duration units like Days, Hours, Minutes, Seconds.
  • There’s no option to format the timeline axis as MMM-YYYY or set granularity to Month.
  • Most advanced Gantt visuals (MAQ, PowerGraph, xViz) require paid subscriptions, which is a blocker for many users.

What I need:

  • A free Gantt visual that supports Month-Year granularity and custom date formatting.
  • Ability to group by Manager and show project bars spanning start and end dates.

Why this matters:

  • Monthly timelines are critical for project planning and reporting.
  • Many organizations rely on Power BI’s free visuals for accessibility and cost control.

Could Microsoft consider adding these features to the default Gantt visual or provide a free alternative?

Project Manager / LeadLead PM Region2nd PMClient NameUPA account No.Project Name (free text)Project/Displacement Overview (free text)Project TypeCustomer SectorLDA customer?Project Region ScopeAnnual Recurring Revenue (GBP)Once off CostPlanned Project Start DateOriginal project End DateRevised Project end date (if applicable)Project PhasePhase StatusSupporting comments for Project phase (Free text)% Complete (manual)RAGIDProject Ref
Manager 1APACPeerPM 1Client 1ACC-1000Project 1[redacted]Strategic - ExecutionFXYes[EMEA]  06-03-202519-12-2025 ExecutionTechnical issue[redacted]46%Red1PRJ-1
Manager 2APACPeerPM 2Client 2ACC-1001Project 2[redacted]New BusinessIBYes[APAC]  26-02-202503-05-2025 ExecutionOn track[redacted]43%Amber2PRJ-2
Manager 3AMERSPeerPM 3Client 3ACC-1002Project 3[redacted]DisplacementFXNo[AMERS]  04-04-202524-08-2025 ExecutionClient Delay[redacted]93%Red3PRJ-3
Manager 4APACPeerPM 4Client 4ACC-1003Project 4[redacted]DisplacementIBNo[APAC]  31-03-202531-03-2026 ExecutionOn track[redacted]73%Green4PRJ-4
Manager 5AMERSPeerPM 5Client 5ACC-1004Project 5[redacted]New BusinessFXYes[AMERS]  17-06-202513-12-2025 ExecutionTechnical issue[redacted]95%Amber5PRJ-5
Manager 6EMEAPeerPM 6Client 6ACC-1005Project 6[redacted]New BusinessCross AssetNo[APAC]  20-07-202515-07-2026 ExecutionTechnical issue[redacted]20%Red6PRJ-6
Manager 7APACPeerPM 7Client 7ACC-1006Project 7[redacted]New BusinessEquitiesYes[AMERS]  05-10-202523-05-2026 ExecutionClient Delay[redacted]51%Red7PRJ-7
Manager 8APACPeerPM 8Client 8ACC-1007Project 8[redacted]DisplacementFXNo[EMEA]  30-03-202519-06-2025 ExecutionTechnical issue[redacted]38%Amber8PRJ-8
Manager 9AMERSPeerPM 9Client 9ACC-1008Project 9[redacted]DisplacementFXNo[AMERS]  10-09-202526-07-2026 ExecutionTechnical issue[redacted]37%Red9PRJ-9
Manager 10AMERSPeerPM 10Client 10ACC-1009Project 10[redacted]DisplacementEquitiesYes[EMEA]  18-09-202510-03-2026 ExecutionTechnical issue[redacted]88%Amber10PRJ-10
Manager 11EMEAPeerPM 11Client 11ACC-1010Project 11[redacted]New BusinessFXYes[AMERS]  09-09-202528-02-2026 ExecutionClient Delay[redacted]56%Red11PRJ-11
Manager 12AMERSPeerPM 12Client 12ACC-1011Project 12[redacted]New BusinessCross AssetNo[AMERS]  26-11-202528-01-2026 ExecutionClient Delay[redacted]48%Amber12PRJ-12
Manager 13APACPeerPM 13Client 13ACC-1012Project 13[redacted]New BusinessCross AssetYes[EMEA]  01-01-202515-11-2025 ExecutionClient Delay[redacted]93%Green13PRJ-13
Manager 14APACPeerPM 14Client 14ACC-1013Project 14[redacted]New BusinessIBNo[AMERS]  09-12-202514-07-2026 ExecutionClient Delay[redacted]80%Red14PRJ-14
Manager 15APACPeerPM 15Client 15ACC-1014Project 15[redacted]New BusinessCross AssetNo[APAC]  02-04-202529-06-2025 ExecutionTechnical issue[redacted]31%Green15PRJ-15
Labels:
Message 1 of 6
1,211 Views
0
5 REPLIES 5
AppleBoy
Frequent Visitor

‎12-01-2025 11:31 PM

Hello @lbendlin 
I am not sure how to use this. I think my originzation has restiricted my toward seeing templates.

Would you be able to suggest any alternative. 

 

Message 5 of 6
1,128 Views
0
lbendlin
Super User
Super User
In response to AppleBoy

‎12-02-2025 10:43 AM

Not sure how this relates to templates?  Here's the link - are you blocked from seeing this?

Deneb: Declarative Visualization in Power BI

Message 6 of 6
1,098 Views
0
Kedar_Pande
Super User
Super User

‎12-01-2025 09:54 PM

@AppleBoy 

 

Matrix workaround:

Rows: Manager → Project Name
Columns: Year-Month (MMM-YYYY)
Values: Start Date flag (1/0), End Date flag (1/0)
Conditional formatting: Background color for duration span

 

 

Message 3 of 6
1,140 Views
0
AppleBoy
Frequent Visitor
In response to Kedar_Pande

‎12-02-2025 01:55 AM

Hello @Kedar_Pande 

I tried this but there then what happens is it only show the projecte is active during a particual month and doesnt show it is active till the end of the project time line. 

The requirement is to show what manager is busy during a year and how they can allocate resource. 

 

Message 4 of 6
1,122 Views
0
lbendlin
Super User
Super User

‎12-01-2025 11:32 AM

There are a couple of Gantt implementations in Vega Lite - you can use the Deneb visual to squeeze your requirements in.

Message 2 of 6
1,168 Views
0

Helpful resources

Announcements
April Power BI Update Carousel

Power BI Monthly Update - April 2026

Check out the April 2026 Power BI update to learn about new features.

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All
Top Solution Authors
View All
Top Kudoed Authors
View All