Ordering in Microsoft's Gantt Visual
I am building a gantt chart using Microsoft's gantt visual extension and I came accross the following issue. I use both task and parent fields when building the visual and I needed to establish a cusom order of displaying the gantt bars. I achieved that by creating sorting columns and sorting the data in data view by those. However when I publish the report into Power BI online services, the ordering breaks. I wonder if anyone had similar issue previously and if it was possible to solve it. Thanks in advance
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?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
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
Gantt 2.2.3 legend problem - bug
Hi all, I am using the Gantt chart 2.2.3 and I believe there is a bug. I need the legend to distiguish between two types of schedule we use for our projects (BL and Actual) The legend works fine (ish) until the start dates for the two categories in legend are the same. Here is what I mean: in the 1. case it works just fine and showing the BL schedule (yellow) and Actual Schedule (blue) correctly - in this case both, the start and the finish date for the BL and Actual Schedule are different. 3. case is a bit problematic, but does not display faulty view at least: in this case start and finish dates for Actual and Baseline Schedule are the same. (this becomes a bit of a problem when a project does not have Baseline Schedule assigned, then it displays them the same - seeming that also the project without BL schedule has BL schedule and the dates are the same as in actual schedule...) However this is not the biggest problem, but would be nice if it could show the line under "shadow" showing that the BL and Actual dates are the same. THE PROBLEM COMES IN EXAMPLE 2: here the start of BL and actual schedule is the same, BUT the finish is different, but the legend is not showing that! This is a very big problem as it shows faulty data. (just an example dates) I have build this view with another gantt chart - Gantt Chart byt MAQ Software and is shows the data correctly and also many testing has been done and there is no mistake in the data.
