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: 

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

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
587 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
504 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
474 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
516 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
498 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
544 Views
0

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.

View All
Top Kudoed Authors
View All