Gantt chart by actual and plan
HI I need to show Gantt chart in power bi report that have tow bar to compare beetween Actual and Plan. I found the Gantt v1.4.3 custome visual in markt place but i can not show to bar . how can i do it like blow pic. I guess this use the gantt custome visual but i can found how show tow bar for uniqe task . is there anyone know?
Customizable background color options in Gantt 3.0.10.0 visual
Hello, I would like to suggest an idea related to the formatting options of Gantt 3.0.10.0 visual. My task is to create a project management portfolio, where projects are displayed on the gantt timeline. I tried various gantt visuals and this visual meet our expectations the most out of the options PBI provides. Since the whole report is in a dark theme, I need the visual to be the same color as well. Unfortunately the part where the task name is displayed has white backgroung and I can´t customize it. Would it be possible to modify the visual so that the user can set the background in the task part himself? I believe that this modification would be beneficial for displaying projects in reports in both dark and light theme. With best regards Sarka
Specific Filtering in a Gannt Chart Based Off Parent Level
I am wanting to be able to filter differently for each different Project, at the parent level. If I select Project1 in a slicer, I only want certain Task items to appear at the task level for that project in the Gantt Chart. I do not need all tasks to show up on the chart. For example, in Project1, there are Tasks 1-9. I only want Tasks 2,4,6 to show up on the chart. Now, if I would switch to Project2, I want the related task items to show up in the Gantt Chart based off the filter specific to Project2. For example, Project2 has Tasks 1-15. I want Tasks 1,3,6,7,8 to show up on the Gantt. The task level items for Project1 and Project2 are not the same and cannot have the same filters applied to them. I do not want the same task numbers to show up on the Gantt chart each time I switch to a different project. Is there a DAX code that will filter tasks based off the Project that has been selected? I was wondering if an IF statement or a SWITCH statement and paired with a FILTER statement, if any of those would work?In Power bi Gantt 2.2.3 , percent completion value becomes 100% after adding legends
Hi , i am using gantt 2.2.3 visualisation to show progress of projects. I want to show legend colour based on project status , but when i am adding the field in legend the % completion is changing to 100% which is incorrect. 45 % is the correct progress. After adding the legend it is changing to 100%.
Schedule, Gantt
Hi, I need some Help, I use Excel to create a schedule, like a Gantt Chart, Imagen: I use this formula to calculate de cells : =SE(MÍNIMO($AB$1-SOMA(AD$8:AD19),$Z20-SOMA($AB20:AC20))=0,"",MÍNIMO($AB$1-SOMA(AD$8:AD19),$Z20-SOMA($AB20:AC20))) SE = IF Mínimo = Min Soma = Sum I need to do the same schedule on power BI. I dont have StarDate and EndDate. it´s need to calculate a daily production of 15000 units, from the current day, when the 15000 closes, needs to switch to the next day with the balance of the previous day and count another 15000.
Remove blank childs in a Gantt chart with parent-child hierarchy
I cannot figure out a way to set up a Gantt chart that shows the full hierarchy (project - lv1, story - lv2, task - lv3), without showing blank childs (or default childs, parent as child). In my hierarchy, some stories (level 2) may not have child tasks, therefore the column "Task - LV3", calculated using PATHITEM, is empty. I am using the Gantt Chart by MAQ Software. I have created a filter measure that, if placed in a matrix with the same dimensions, only shows childs if a parent have some: Remove Blanks = SWITCH(TRUE(),AND(ISINSCOPE(Table[Level2]), ISBLANK(VALUES(Table[Level2]))), BLANK(), AND(ISINSCOPE(Table[Level3]), ISBLANK(VALUES(Table[Level3]))), BLANK(),1) However, I cannot find a way to make it work in the Gantt Chart. If I try to use it as a filter, it will only shows full hierarchies, namely items that have lv1 & lv2 & lv3, therefore losing all the stories (lv2) and projects (lv1) that do not have tasks (lv3). Can someone help? Thanks
Display milestones on tasks in timeline
I'm trying to visualize incidents over time, and have been trying to adapt a variety of gantt chart custom visuals to my purposes. I want something that looks like this: The essential elements are: -Timeline -Multiple tasks -Milestones assigned to tasks and displaying on task -Labels on milestones -Different types of milestones -Multiple milestones per task Does anything like this already exist?
Gantt Chart Half Days
Hello, I am trying to create a gantt chart to display a construction schedule. We occasionally have tasks which take 12h, or half a day assuming 24h work. My dataset recognizes that the task is only 12h. It starts at 7am and ends at 7pm, with the following task starting at 7pm and ending at 7am. So two tasks have been scheduled for one 24h block. See the "Calculated Scheduled Start/End Time" columns below. On the Gantt chart, each of these 12h tasks are being displayed as 24h, but maintaining the correct start times. As a result, the durations are incorrect and there is overlap between subsequent tasks ("Mobilize" and "Rig up"). Does the graphing component just have a minimum duration of one day? Is there any known workarounds for this? I would like to display this schedule accurately. Any help would be greatly appreciated. Thanks
Gantt Chart visual limitations
I've built prototype reports based upon several differrent Gantt Chart custom visuals. Some come pretty close to what I need, but they all seem to have limitations that restrict the use of measures, in particular, for start date, end date and category/progress. Is this a technical limitation of some sort, or could the limitation be overcome with some custom programming?Show summary in table based on selected value in Gantt Chart (by making use of a measure)
Hi, I have a Gantt chart and would like to show more information when someone clicks on one of the bars in the chart. The bars represent parts of products (ID 4 and 5 in the table). When a bar (part) is selected I want to show the summary of the issue which is linked to this part. E.g. when someone selects ID 4 (Part 4), the table should show the summary "XYQ" of ID 1 (issue 1). How can I write a measure which allows a table to display only the issues which are linked to the selected part? There is a path available which works from higher levels (Product, part, sub part, issue) to lower levels. Furthermore, this path is available in separate columns, so issues have a link to Part ID included. However, Parts do not have a direct link to Issues. ID Summary Type Parent Path Product ID (LVL1) Part ID (LVL2) Sub Part ID (LVL3) Issue ID (LVL4) 1 XYQ Issue 3 3|4|2|1 3 4 2 1 2 ABC Sub-part 4 3|4|2 3 4 2 3 DEF Product 6 3 3 - - 4 GHI Part 3 3|4 3 4 - 5 DJI Part 3 3|5 3 5 - My intuition says the measure should allow to show "all summaries", of “all issues” which have “the Selected Parts’ ID” in their own “Part ID column”. Thank you so much, Gijs
