Hi everyone,
I’m trying to build a Gantt-like visualization in Power BI using only native features and DAX, since the custom visuals that provide these functionalities are mostly paid. I have two tables:
FClick: This is my main tasks table, containing task details such as:Important: because each task can have multiple tags, there can be multiple rows for the same task id in this table — one per tag.
- id (task identifier)
- name (task name)
- date_created (task start date)
- due_date (task end date)
- status_name (task status: e.g., Completed, In Progress, Pending, etc.)
- tags (each task can have multiple tags)
DimTarefa: This is a calculated (derived) table I created based on FClick, which organizes tasks into a hierarchical structure with columns such as:
- ID (task identifier)
- ParentID (ID of the parent task)
- Level (hierarchy level, e.g., 1 for top level, higher numbers for subtasks)
- FullPath (concatenated path of task IDs from root to current task)
- Tarefa_N1, Tarefa_N2, ..., Tarefa_N4 (task names at each hierarchy level.
It would be great if the bars could be colored based on task status and intermediate empty nodes were not displayed, these are two main issues I’ve encountered. I’ve searched for solutions without success. Any advice on how to move forward would be appreciated.
