topic Re: Need Month-Year Granularity in Free Gantt Visual for Power BI in Custom Visuals Development Discussion https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Need-Month-Year-Granularity-in-Free-Gantt-Visual-for-Power-BI/m-p/4889944#M12964 <P>There are a couple of Gantt implementations in Vega Lite - you can use the Deneb visual to squeeze your requirements in.</P> Mon, 01 Dec 2025 19:32:32 GMT lbendlin 2025-12-01T19:32:32Z Need Month-Year Granularity in Free Gantt Visual for Power BI https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Need-Month-Year-Granularity-in-Free-Gantt-Visual-for-Power-BI/m-p/4889463#M12962 <P>Hi Team,<BR />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.</P><P>Current challenges:</P><UL><LI>The <STRONG>Microsoft Gantt visual</STRONG> only supports duration units like Days, Hours, Minutes, Seconds.</LI><LI>There’s no option to format the timeline axis as <STRONG>MMM-YYYY</STRONG> or set granularity to Month.</LI><LI>Most advanced Gantt visuals (MAQ, PowerGraph, xViz) require paid subscriptions, which is a blocker for many users.</LI></UL><P>What I need:</P><UL><LI>A <STRONG>free Gantt visual</STRONG> that supports Month-Year granularity and custom date formatting.</LI><LI>Ability to group by Manager and show project bars spanning start and end dates.</LI></UL><P>Why this matters:</P><UL><LI>Monthly timelines are critical for project planning and reporting.</LI><LI>Many organizations rely on Power BI’s free visuals for accessibility and cost control.</LI></UL><P>Could Microsoft consider adding these features to the default Gantt visual or provide a free alternative?</P><TABLE><TBODY><TR><TD>Project Manager / Lead</TD><TD>Lead PM Region</TD><TD>2nd PM</TD><TD>Client Name</TD><TD>UPA account No.</TD><TD>Project Name (free text)</TD><TD>Project/Displacement Overview (free text)</TD><TD>Project Type</TD><TD>Customer Sector</TD><TD>LDA customer?</TD><TD>Project Region Scope</TD><TD>Annual Recurring Revenue (GBP)</TD><TD>Once off Cost</TD><TD>Planned Project Start Date</TD><TD>Original project End Date</TD><TD>Revised Project end date (if applicable)</TD><TD>Project Phase</TD><TD>Phase Status</TD><TD>Supporting comments for Project phase (Free text)</TD><TD>% Complete (manual)</TD><TD>RAG</TD><TD>ID</TD><TD>Project Ref</TD></TR><TR><TD>Manager 1</TD><TD>APAC</TD><TD>PeerPM 1</TD><TD>Client 1</TD><TD>ACC-1000</TD><TD>Project 1</TD><TD>[redacted]</TD><TD>Strategic - Execution</TD><TD>FX</TD><TD>Yes</TD><TD>[EMEA]</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>06-03-2025</TD><TD>19-12-2025</TD><TD>&nbsp;</TD><TD>Execution</TD><TD>Technical issue</TD><TD>[redacted]</TD><TD>46%</TD><TD>Red</TD><TD>1</TD><TD>PRJ-1</TD></TR><TR><TD>Manager 2</TD><TD>APAC</TD><TD>PeerPM 2</TD><TD>Client 2</TD><TD>ACC-1001</TD><TD>Project 2</TD><TD>[redacted]</TD><TD>New Business</TD><TD>IB</TD><TD>Yes</TD><TD>[APAC]</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>26-02-2025</TD><TD>03-05-2025</TD><TD>&nbsp;</TD><TD>Execution</TD><TD>On track</TD><TD>[redacted]</TD><TD>43%</TD><TD>Amber</TD><TD>2</TD><TD>PRJ-2</TD></TR><TR><TD>Manager 3</TD><TD>AMERS</TD><TD>PeerPM 3</TD><TD>Client 3</TD><TD>ACC-1002</TD><TD>Project 3</TD><TD>[redacted]</TD><TD>Displacement</TD><TD>FX</TD><TD>No</TD><TD>[AMERS]</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>04-04-2025</TD><TD>24-08-2025</TD><TD>&nbsp;</TD><TD>Execution</TD><TD>Client Delay</TD><TD>[redacted]</TD><TD>93%</TD><TD>Red</TD><TD>3</TD><TD>PRJ-3</TD></TR><TR><TD>Manager 4</TD><TD>APAC</TD><TD>PeerPM 4</TD><TD>Client 4</TD><TD>ACC-1003</TD><TD>Project 4</TD><TD>[redacted]</TD><TD>Displacement</TD><TD>IB</TD><TD>No</TD><TD>[APAC]</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>31-03-2025</TD><TD>31-03-2026</TD><TD>&nbsp;</TD><TD>Execution</TD><TD>On track</TD><TD>[redacted]</TD><TD>73%</TD><TD>Green</TD><TD>4</TD><TD>PRJ-4</TD></TR><TR><TD>Manager 5</TD><TD>AMERS</TD><TD>PeerPM 5</TD><TD>Client 5</TD><TD>ACC-1004</TD><TD>Project 5</TD><TD>[redacted]</TD><TD>New Business</TD><TD>FX</TD><TD>Yes</TD><TD>[AMERS]</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>17-06-2025</TD><TD>13-12-2025</TD><TD>&nbsp;</TD><TD>Execution</TD><TD>Technical issue</TD><TD>[redacted]</TD><TD>95%</TD><TD>Amber</TD><TD>5</TD><TD>PRJ-5</TD></TR><TR><TD>Manager 6</TD><TD>EMEA</TD><TD>PeerPM 6</TD><TD>Client 6</TD><TD>ACC-1005</TD><TD>Project 6</TD><TD>[redacted]</TD><TD>New Business</TD><TD>Cross Asset</TD><TD>No</TD><TD>[APAC]</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>20-07-2025</TD><TD>15-07-2026</TD><TD>&nbsp;</TD><TD>Execution</TD><TD>Technical issue</TD><TD>[redacted]</TD><TD>20%</TD><TD>Red</TD><TD>6</TD><TD>PRJ-6</TD></TR><TR><TD>Manager 7</TD><TD>APAC</TD><TD>PeerPM 7</TD><TD>Client 7</TD><TD>ACC-1006</TD><TD>Project 7</TD><TD>[redacted]</TD><TD>New Business</TD><TD>Equities</TD><TD>Yes</TD><TD>[AMERS]</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>05-10-2025</TD><TD>23-05-2026</TD><TD>&nbsp;</TD><TD>Execution</TD><TD>Client Delay</TD><TD>[redacted]</TD><TD>51%</TD><TD>Red</TD><TD>7</TD><TD>PRJ-7</TD></TR><TR><TD>Manager 8</TD><TD>APAC</TD><TD>PeerPM 8</TD><TD>Client 8</TD><TD>ACC-1007</TD><TD>Project 8</TD><TD>[redacted]</TD><TD>Displacement</TD><TD>FX</TD><TD>No</TD><TD>[EMEA]</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>30-03-2025</TD><TD>19-06-2025</TD><TD>&nbsp;</TD><TD>Execution</TD><TD>Technical issue</TD><TD>[redacted]</TD><TD>38%</TD><TD>Amber</TD><TD>8</TD><TD>PRJ-8</TD></TR><TR><TD>Manager 9</TD><TD>AMERS</TD><TD>PeerPM 9</TD><TD>Client 9</TD><TD>ACC-1008</TD><TD>Project 9</TD><TD>[redacted]</TD><TD>Displacement</TD><TD>FX</TD><TD>No</TD><TD>[AMERS]</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>10-09-2025</TD><TD>26-07-2026</TD><TD>&nbsp;</TD><TD>Execution</TD><TD>Technical issue</TD><TD>[redacted]</TD><TD>37%</TD><TD>Red</TD><TD>9</TD><TD>PRJ-9</TD></TR><TR><TD>Manager 10</TD><TD>AMERS</TD><TD>PeerPM 10</TD><TD>Client 10</TD><TD>ACC-1009</TD><TD>Project 10</TD><TD>[redacted]</TD><TD>Displacement</TD><TD>Equities</TD><TD>Yes</TD><TD>[EMEA]</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>18-09-2025</TD><TD>10-03-2026</TD><TD>&nbsp;</TD><TD>Execution</TD><TD>Technical issue</TD><TD>[redacted]</TD><TD>88%</TD><TD>Amber</TD><TD>10</TD><TD>PRJ-10</TD></TR><TR><TD>Manager 11</TD><TD>EMEA</TD><TD>PeerPM 11</TD><TD>Client 11</TD><TD>ACC-1010</TD><TD>Project 11</TD><TD>[redacted]</TD><TD>New Business</TD><TD>FX</TD><TD>Yes</TD><TD>[AMERS]</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>09-09-2025</TD><TD>28-02-2026</TD><TD>&nbsp;</TD><TD>Execution</TD><TD>Client Delay</TD><TD>[redacted]</TD><TD>56%</TD><TD>Red</TD><TD>11</TD><TD>PRJ-11</TD></TR><TR><TD>Manager 12</TD><TD>AMERS</TD><TD>PeerPM 12</TD><TD>Client 12</TD><TD>ACC-1011</TD><TD>Project 12</TD><TD>[redacted]</TD><TD>New Business</TD><TD>Cross Asset</TD><TD>No</TD><TD>[AMERS]</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>26-11-2025</TD><TD>28-01-2026</TD><TD>&nbsp;</TD><TD>Execution</TD><TD>Client Delay</TD><TD>[redacted]</TD><TD>48%</TD><TD>Amber</TD><TD>12</TD><TD>PRJ-12</TD></TR><TR><TD>Manager 13</TD><TD>APAC</TD><TD>PeerPM 13</TD><TD>Client 13</TD><TD>ACC-1012</TD><TD>Project 13</TD><TD>[redacted]</TD><TD>New Business</TD><TD>Cross Asset</TD><TD>Yes</TD><TD>[EMEA]</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>01-01-2025</TD><TD>15-11-2025</TD><TD>&nbsp;</TD><TD>Execution</TD><TD>Client Delay</TD><TD>[redacted]</TD><TD>93%</TD><TD>Green</TD><TD>13</TD><TD>PRJ-13</TD></TR><TR><TD>Manager 14</TD><TD>APAC</TD><TD>PeerPM 14</TD><TD>Client 14</TD><TD>ACC-1013</TD><TD>Project 14</TD><TD>[redacted]</TD><TD>New Business</TD><TD>IB</TD><TD>No</TD><TD>[AMERS]</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>09-12-2025</TD><TD>14-07-2026</TD><TD>&nbsp;</TD><TD>Execution</TD><TD>Client Delay</TD><TD>[redacted]</TD><TD>80%</TD><TD>Red</TD><TD>14</TD><TD>PRJ-14</TD></TR><TR><TD>Manager 15</TD><TD>APAC</TD><TD>PeerPM 15</TD><TD>Client 15</TD><TD>ACC-1014</TD><TD>Project 15</TD><TD>[redacted]</TD><TD>New Business</TD><TD>Cross Asset</TD><TD>No</TD><TD>[APAC]</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>02-04-2025</TD><TD>29-06-2025</TD><TD>&nbsp;</TD><TD>Execution</TD><TD>Technical issue</TD><TD>[redacted]</TD><TD>31%</TD><TD>Green</TD><TD>15</TD><TD>PRJ-15</TD></TR></TBODY></TABLE> Mon, 01 Dec 2025 09:03:18 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Need-Month-Year-Granularity-in-Free-Gantt-Visual-for-Power-BI/m-p/4889463#M12962 AppleBoy 2025-12-01T09:03:18Z Re: Need Month-Year Granularity in Free Gantt Visual for Power BI https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Need-Month-Year-Granularity-in-Free-Gantt-Visual-for-Power-BI/m-p/4889944#M12964 <P>There are a couple of Gantt implementations in Vega Lite - you can use the Deneb visual to squeeze your requirements in.</P> Mon, 01 Dec 2025 19:32:32 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Need-Month-Year-Granularity-in-Free-Gantt-Visual-for-Power-BI/m-p/4889944#M12964 lbendlin 2025-12-01T19:32:32Z Re: Need Month-Year Granularity in Free Gantt Visual for Power BI https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Need-Month-Year-Granularity-in-Free-Gantt-Visual-for-Power-BI/m-p/4890281#M12965 <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/1358802">@AppleBoy</a>&nbsp;</P> <P>&nbsp;</P> <P>Matrix workaround:</P> <P>Rows: Manager → Project Name<BR />Columns: Year-Month (MMM-YYYY)<BR />Values: Start Date flag (1/0), End Date flag (1/0)<BR />Conditional formatting: Background color for duration span</P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 02 Dec 2025 05:54:47 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Need-Month-Year-Granularity-in-Free-Gantt-Visual-for-Power-BI/m-p/4890281#M12965 Kedar_Pande 2025-12-02T05:54:47Z Re: Need Month-Year Granularity in Free Gantt Visual for Power BI https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Need-Month-Year-Granularity-in-Free-Gantt-Visual-for-Power-BI/m-p/4890415#M12966 <P>Hello&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/100342">@lbendlin</a>&nbsp;<BR />I am not sure how to use this. I think my originzation has restiricted my toward seeing templates.</P><P>Would you be able to suggest any alternative.&nbsp;</P><P>&nbsp;</P> Tue, 02 Dec 2025 07:31:52 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Need-Month-Year-Granularity-in-Free-Gantt-Visual-for-Power-BI/m-p/4890415#M12966 AppleBoy 2025-12-02T07:31:52Z Re: Need Month-Year Granularity in Free Gantt Visual for Power BI https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Need-Month-Year-Granularity-in-Free-Gantt-Visual-for-Power-BI/m-p/4890539#M12967 <P>Hello&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/568855">@Kedar_Pande</a>&nbsp;</P><P>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.&nbsp;</P><P>The requirement is to show what manager is busy during a year and how they can allocate resource.&nbsp;</P><P>&nbsp;</P> Tue, 02 Dec 2025 09:55:36 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Need-Month-Year-Granularity-in-Free-Gantt-Visual-for-Power-BI/m-p/4890539#M12967 AppleBoy 2025-12-02T09:55:36Z Re: Need Month-Year Granularity in Free Gantt Visual for Power BI https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Need-Month-Year-Granularity-in-Free-Gantt-Visual-for-Power-BI/m-p/4891028#M12968 <P>Not sure how this relates to templates?&nbsp; Here's the link - are you blocked from seeing this?</P> <P><A href="https://marketplace.microsoft.com/en-us/product/power-bi-visuals/coacervolimited1596856650797.deneb?tab=overview" target="_blank">Deneb: Declarative Visualization in Power BI</A></P> Tue, 02 Dec 2025 18:43:48 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Need-Month-Year-Granularity-in-Free-Gantt-Visual-for-Power-BI/m-p/4891028#M12968 lbendlin 2025-12-02T18:43:48Z