Resource Conflict Visualization in a Gantt-like Chart

[PowerB_han]

Hello Community,

We are looking for a way to visualize resource conflicts within a project timeline, similar to a Gantt chart, but with additional capabilities.

Our goal is to create a visual that:

1. Displays task progress sorted by resource, much like the xViz Gantt Chart.
2. Allows comparison of resource tasks with their vacation/absence periods.
3. Highlights or alerts the user when a task and a vacation/absence period for the same resource overlap. We'd like to be able to set a condition for this, so it's visually apparent to the user (e.g., color change, icon, etc.).

Essentially, we want to detect and visualize "resource conflicts" where a resource is scheduled for a task but also marked as absent (due to vacation, sick leave, etc.) during that same period.

Any ideas, suggestions, or examples of how this could be achieved in Power BI (perhaps with custom visuals, DAX logic, or specific chart types) would be greatly appreciated!

Thanks to the entire community for your help!

[PowerB_han]

Many thanks to all that helped me on this topic.

Problem has been solved!

[v-saisrao-msft]

Hi @PowerB_han,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.

[kushanNa]

hi @PowerB_han 

Are you looking for an output similar to this?

Please note that this is not a Power BI visual; I’m just trying to get an idea of what you are looking for here.

[PowerB_han]

Thank you for your response.

It's still not entirely clear to me how you implement the logic.
(Key DAX Logic)

Is this only possible with the Premium version?

Are there ways to display this with a free visual?

It doesn't necessarily have to be a Gantt chart; we are concerned with detecting resource conflicts.

Thank you in advance!

[v-saisrao-msft · Accepted solution]

Hi @PowerB_han,

Thank you @rohit1991 @jaineshp @kushanNa, for your helpful insights.

I recreated your scenario in Power BI Desktop using sample data and implemented the conflict detection logic with a calculated column instead of a measure. You don’t need the premium xViz Gantt visual everything can be achieved using native visuals like a Table or Matrix to display tasks along with their conflict status.

Belos is the pbic file for your reference.

Thank you.

[jaineshp]

Hey @v-saisrao-msft,

Thank you for the kind recognition - always happy to contribute to our community's success!

Best Regards,
Jainesh Poojara | Power BI Developer

[rohit1991]

Hi @PowerB_han 

You can achieve this using the xViz Gantt Chart in Power BI.

1. Append your Tasks and Absences into one table with Resource, Event Type, Start Date, and End Date.

2. Create a conflict flag (using DAX or Power Query) to detect overlaps between task and absence dates for the same resource.

3. In the xViz Gantt visual, use conditional formatting to color tasks differently when there's a conflict, and assign a separate color to absence blocks.

4. Optionally, add tooltips or icons to clearly indicate the overlapping period.

This setup will let you visualize tasks and absences together and clearly highlight conflicts directly on the timeline.

[jaineshp]

Hey @PowerB_han,

I've worked on similar requirements in my organization and here's what we implemented successfully:

Data Structure We Used

• Tasks Table: Keep it simple - TaskID, ResourceID, TaskName, StartDate, EndDate, CompletionPercentage
• Resources Master: ResourceID, ResourceName, TeamLead, CostCenter
• Leave Calendar: ResourceID, LeaveType, FromDate, ToDate, ApprovalStatus
• Working Calendar: Standard Power BI date table with working day flags

Key DAX Logic That Works

• Main Conflict Identifier:
  IsConflicted =
  VAR CurrentTaskStart = Tasks[StartDate]
  VAR CurrentTaskEnd = Tasks[EndDate]
  VAR CurrentResource = Tasks[ResourceID]
  RETURN
  CALCULATE(
  IF(COUNTROWS(LeaveCalendar) > 0, "CONFLICT", "CLEAR"),
  LeaveCalendar[ResourceID] = CurrentResource,
  LeaveCalendar[FromDate] <= CurrentTaskEnd,
  LeaveCalendar[ToDate] >= CurrentTaskStart
  )
• Overlap Duration:
  ConflictDays =
  DATEDIFF(
  MAX(Tasks[StartDate], LeaveCalendar[FromDate]),
  MIN(Tasks[EndDate], LeaveCalendar[ToDate]),
  DAY
  ) + 1

Visual Implementation Steps

• Primary Chart: We used xViz Gantt Pro (worth the investment)
• Sorting: Resources grouped alphabetically, then by task priority
• Color Scheme:
  • Red bars for conflicted tasks
  • Orange for partial conflicts (weekends/holidays only)
  • Standard blue for clear tasks
• Legend: Simple traffic light system that everyone understands

Additionally: - Start simple and add complexity gradually. Users need time to adapt to new visuals.

Hope this helps with your project! Let me know how it goes.

Fixed? ✓ Mark it • Share it • Help others!

Best Regards,
Jainesh Poojara | Power BI Developer