Forum Discussion
Resource Conflict Visualization in a Gantt-like Chart
Hi Anonymous,
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.
Super UserHi Anonymous
You can achieve this using the xViz Gantt Chart in Power BI.
-
Append your Tasks and Absences into one table with Resource, Event Type, Start Date, and End Date.
-
Create a conflict flag (using DAX or Power Query) to detect overlaps between task and absence dates for the same resource.
-
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.
-
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.