User Profile

AppleBoy

Frequent Visitor

Joined 10 months ago

8 Posts

View All Badges

User Widgets

Contributions

Re: Need Month-Year Granularity in Free Gantt Visual for Power BI
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.
8 months ago Place Custom Visuals Development Discussion
1.4KViews
0likes
0Comments
Re: Need Month-Year Granularity in Free Gantt Visual for Power BI
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.
8 months ago Place Custom Visuals Development Discussion
1.4KViews
0likes
1Comment
Need Month-Year Granularity in Free Gantt Visual for Power BI
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 / Lead Lead PM Region 2nd PM Client Name UPA account No. Project Name (free text) Project/Displacement Overview (free text) Project Type Customer Sector LDA customer? Project Region Scope Annual Recurring Revenue (GBP) Once off Cost Planned Project Start Date Original project End Date Revised Project end date (if applicable) Project Phase Phase Status Supporting comments for Project phase (Free text) % Complete (manual) RAG ID Project Ref Manager 1 APAC PeerPM 1 Client 1 ACC-1000 Project 1 [redacted] Strategic - Execution FX Yes [EMEA] 06-03-2025 19-12-2025 Execution Technical issue [redacted] 46% Red 1 PRJ-1 Manager 2 APAC PeerPM 2 Client 2 ACC-1001 Project 2 [redacted] New Business IB Yes [APAC] 26-02-2025 03-05-2025 Execution On track [redacted] 43% Amber 2 PRJ-2 Manager 3 AMERS PeerPM 3 Client 3 ACC-1002 Project 3 [redacted] Displacement FX No [AMERS] 04-04-2025 24-08-2025 Execution Client Delay [redacted] 93% Red 3 PRJ-3 Manager 4 APAC PeerPM 4 Client 4 ACC-1003 Project 4 [redacted] Displacement IB No [APAC] 31-03-2025 31-03-2026 Execution On track [redacted] 73% Green 4 PRJ-4 Manager 5 AMERS PeerPM 5 Client 5 ACC-1004 Project 5 [redacted] New Business FX Yes [AMERS] 17-06-2025 13-12-2025 Execution Technical issue [redacted] 95% Amber 5 PRJ-5 Manager 6 EMEA PeerPM 6 Client 6 ACC-1005 Project 6 [redacted] New Business Cross Asset No [APAC] 20-07-2025 15-07-2026 Execution Technical issue [redacted] 20% Red 6 PRJ-6 Manager 7 APAC PeerPM 7 Client 7 ACC-1006 Project 7 [redacted] New Business Equities Yes [AMERS] 05-10-2025 23-05-2026 Execution Client Delay [redacted] 51% Red 7 PRJ-7 Manager 8 APAC PeerPM 8 Client 8 ACC-1007 Project 8 [redacted] Displacement FX No [EMEA] 30-03-2025 19-06-2025 Execution Technical issue [redacted] 38% Amber 8 PRJ-8 Manager 9 AMERS PeerPM 9 Client 9 ACC-1008 Project 9 [redacted] Displacement FX No [AMERS] 10-09-2025 26-07-2026 Execution Technical issue [redacted] 37% Red 9 PRJ-9 Manager 10 AMERS PeerPM 10 Client 10 ACC-1009 Project 10 [redacted] Displacement Equities Yes [EMEA] 18-09-2025 10-03-2026 Execution Technical issue [redacted] 88% Amber 10 PRJ-10 Manager 11 EMEA PeerPM 11 Client 11 ACC-1010 Project 11 [redacted] New Business FX Yes [AMERS] 09-09-2025 28-02-2026 Execution Client Delay [redacted] 56% Red 11 PRJ-11 Manager 12 AMERS PeerPM 12 Client 12 ACC-1011 Project 12 [redacted] New Business Cross Asset No [AMERS] 26-11-2025 28-01-2026 Execution Client Delay [redacted] 48% Amber 12 PRJ-12 Manager 13 APAC PeerPM 13 Client 13 ACC-1012 Project 13 [redacted] New Business Cross Asset Yes [EMEA] 01-01-2025 15-11-2025 Execution Client Delay [redacted] 93% Green 13 PRJ-13 Manager 14 APAC PeerPM 14 Client 14 ACC-1013 Project 14 [redacted] New Business IB No [AMERS] 09-12-2025 14-07-2026 Execution Client Delay [redacted] 80% Red 14 PRJ-14 Manager 15 APAC PeerPM 15 Client 15 ACC-1014 Project 15 [redacted] New Business Cross Asset No [APAC] 02-04-2025 29-06-2025 Execution Technical issue [redacted] 31% Green 15 PRJ-15
8 months ago Place Custom Visuals Development Discussion
"Need Help"
1.5KViews
0likes
5Comments
Need Help Creating a Unified Table Visual from Multiple Unrelated Data Sources in Power BI
I’m working on a Power BI dashboard that pulls data from five different sources, each with its own schema and no relationships between them. Each source contains its own date field and unique measures. I want to create a single table visual that: Uses a common date column (Month/Year) in the table Displays two measures side-by-side: Total Sales Closed (from one source) Total Tasks Closed (from another source) The goal is to synchronize these measures by date, even though the datasets are unrelated. What I’ve Tried: Created a disconnected Date table using CALENDAR() and added columns like Year, Month, and YearMonth. Used TREATAS in DAX to align each measure with the disconnected Date table. Created a new column to strip time from the datetime fields using INT() and DATEVALUE(). Built measures using CALCULATE + FILTER + TREATAS. Despite this, the measures return blank values in the visual. Request: I need guidance on: How to correctly sync measures from unrelated datasets using a disconnected Date table. Why the current approach using TREATAS and cleaned date columns might be failing. Best practices for building a unified visual when sources are not related.
Solved
10 months ago Place Desktop
Need Help
476Views
0likes
3Comments
Re: DAX Measure for Rolling 3-Month Average Not Working as Expected

10 months ago Place DAX Commands and Tips
1.8KViews
0likes
0Comments
Re: DAX Measure for Rolling 3-Month Average Not Working as Expected
Sample Data (First 8 Rows) Number Name Opportunity Id State Portfolio Demand manager Client name City Country Project Start Date Opened Date Of Demand Created Closed Deferred reason Order type Date Of Project Created Created by State.1 Time Working Hours Region Status T1DMD0078705 US - Akamai Technologies, Inc - Switch to WC API 6053098.0 Deferred WorldCheck Roy Taylor Akamai Technologies, Inc Cambridge United States nan 2025-05-30 00:00:00 2025-05-30 23:31:50 2025-05-30 23:31:50 2025-06-02 19:46:38 Products/Service Out of Scope Pilot NaT nan nan -1099391.5305555556 0.0 AMERS Pending T1DMD0078690 Starter - Allan Gray Proprietary Limited-EMEA-One API - One API 6401149.0 Completed WorldCheck Jean Bruno Kinguenguy Allan Gray Proprietary Limited Cape Town South Africa Starter - Allan Gray Proprietary Limited-EMEA-One API - One API 2025-05-30 00:00:00 2025-05-30 18:54:39 2025-05-30 18:54:39 2025-05-30 19:46:09 nan Pilot 2025-05-30 19:46:07 jkinguen Work in Progress 0.8577777776517905 0.8577777776517905 EMEA Closed T1DMD0078663 Starter - PLUS500 LTD-EMEA-One API - One API 6474971.0 Completed WorldCheck Himalaya Garg PLUS500 LTD Haifa Israel Starter - PLUS500 LTD-EMEA-One API - One API 2025-05-30 00:00:00 2025-05-30 12:50:11 2025-05-30 12:50:11 2025-05-30 13:32:31 nan Pilot 2025-05-30 13:32:29 hgarg Work in Progress 0.7050000001327135 0.7050000001327135 EMEA Closed T1DMD0078621 Grab - DS Work nan Completed WorldCheck Ray Sun GP Network Asia Pte. Ltd. Singapore Singapore Grab - DS Work 2025-05-29 00:00:00 2025-05-29 14:11:43 2025-05-29 14:17:48 2025-05-29 14:23:11 nan nan 2025-05-29 14:23:10 rsun1 Work in Progress 0.08944444439839572 0.08944444439839572 nan Closed T1DMD0078598 Starter - Shelf Drilling Holdings, Ltd - Amers - One API - One API 6369707.0 Completed WorldCheck Ray Sun Shelf Drilling Holdings, Ltd George Town Cayman Islands Starter - Shelf Drilling Holdings, Ltd - Amers - One API - One API 2025-05-29 00:00:00 2025-05-29 02:08:52 2025-05-29 02:08:53 2025-05-29 08:10:45 nan Pilot 2025-05-29 08:10:44 rsun1 Closed Skipped 6.030833333381452 6.030833333381452 AMERS Closed T1DMD0078574 Atlas Consolidated Pte Ltd-Asia-One API - One API 6083687.0 Completed WorldCheck Vikram M V Atlas Consolidated Pte Ltd Singapore Singapore Atlas Consolidated Pte Ltd-Asia-One API - One API 2025-05-28 00:00:00 2025-05-28 16:40:10 2025-05-28 16:40:10 2025-05-29 09:28:17 nan Pilot 2025-05-29 09:28:15 vmv Pending 16.801388888969086 16.80111111119131 ASIA Closed T1DMD0078543 IGT Global Solutions Corporation - Americas - OneAPI - One API 6348389.0 Completed WorldCheck Judith Pillado IGT Global Solutions Corporation Providence United States IGT Global Solutions Corporation - Americas - OneAPI - One API 2025-05-28 00:00:00 2025-05-28 04:14:46 2025-05-28 04:14:46 2025-05-29 07:27:59 nan Pilot 2025-05-29 07:27:57 jpillado Pending 27.219722222245764 27.21944444446799 AMERS Closed T1DMD0078531 Advanced - Summit Bank -EMEA-One API - One API 6502796.0 Completed WorldCheck Jean Bruno Kinguenguy Summit Bank Jahi Abuja Nigeria Advanced - Summit Bank -EMEA-One API - One API 2025-05-27 00:00:00 2025-05-27 21:13:12 2025-05-27 21:13:12 2025-05-28 13:08:56 nan Pilot 2025-05-28 13:08:55 jkinguen Closed Skipped 15.928611111128703 15.928333333350926 EMEA Closed Expected Outcome Attached is sample data, working hrs =LET(StartDay,M18,EndDay,Q18,DayStart,TIME(0,0,0),DayEnd,TIME(23,59,59), incStart,NETWORKDAYS(StartDay,StartDay), incEnd,NETWORKDAYS(EndDay,EndDay), This is what is expected: When avaliable for the previous three month it should calculate for the 4th month Data Model Diagram Data model diagram could not be added.
10 months ago Place DAX Commands and Tips
1.7KViews
0likes
0Comments
Re: DAX Measure for Rolling 3-Month Average Not Working as Expected
It doesnt work. It is result in the avg of working hrs. The goal is to get the avg of the jan feb and march in the moth on april
10 months ago Place DAX Commands and Tips
1.9KViews
0likes
3Comments
DAX Measure for Rolling 3-Month Average Not Working as Expected
I’m trying to calculate a rolling 3-month average of a calculated column Working_Hours in Power BI. The logic should behave like Excel’s moving average: For the first few months, it should return a cumulative average until 3 months of data are available. From the 4th month onward, it should return a rolling average of the previous three months for example For April - It should consider Jan feb and march For may Feb, march and Aprile. I’ve created a Metric Month column using EOMONTH([Closed_date], 0) and a calculated column Working_Hours that excludes weekends using a Calendar table. However, the DAX measure I’ve written is returning incorrect values — either the same value across all months or inflated numbers that don’t match the expected logic. I’ve tried using DATESINPERIOD, FILTER, and CALCULATE with AVERAGE, but the measure doesn’t respect the month context correctly. I’ve also ensured that the Calendar table is related to the Metric Month column. Could you please help me with the correct DAX measure or advise on how to structure this calculation properly?
Solved
10 months ago Place DAX Commands and Tips
2KViews
0likes
9Comments

Data Privacy

Microsoft Fabric Community and Privacy

To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.