So instead of letting the Gantt chart create an implied measure we can create our own measure and use that instead. What is happening is that the Gantt chart is creating an implied measure when we pass in the column.
The Gantt Chart visual can be used to show current schedule status using percent-complete shadings and a vertical 'TODAY' line. The Gantt Chart visual shows the Tasks, Start Dates, Durations, Complete, and Resources for a project. The second interesting thing that I noticed from the captured query is that is being used as a grouping column in the SUMMARIZECOLUMNS() function, but is getting the earliest end using CALCULATE(MIN('Table1')). A Gantt chart is a type of bar chart which illustrates a project timeline or schedule. If we replace the 'Table1' field used in the slicer that “fixes” our issue of start dates earlier than those in the slicer being filtered out, but now our slicer is not filtering the data at all, but all is not lost, we will fix that next. Video content main chapters:00:00 Video start03:20 GANTT chart by Lingaro10:48 as Timeline visual16:06 GANTT by xVizIn this follow up video I'm looking at 3. In the demo file I simply created a calculated table using Date Slicer = CALENDARAUTO() but you can use whatever method you like to create this table. To fix this we need to create a separate date table that does not have a relationship to our main fact table. Obviously this is going to cause an issue as events that are already in-progress will have a start date before the earliest date in the slicer.
There are two important parts to notice from the above query.įirst is that the filter is currently explicitly filtering for start dates based on the values selected in the slicer. This captured the following query for the Gantt visual: To figure out what options we had to change this default behaviour I turned on the Performance Profiler in Power BI Desktop (I could also have used the All Queries trace in DAX Studio).
It was not showing tasks which were already in progress like the first two (Division… and Functional…). Given the following data, what he wanted was to filter the data for dates between Mar-20 to Apr-10 so that the Gantt chart would show the section in Yellow below:īut he was getting output like the following, where it was only showing the bottom 3 tasks from the image above with a start date between Mar-20 and Apr-10. Let’s start by looking at an example of the issue he was dealing with. I figured out a way to get this working and I thought it might be helpful to not just show the solution, but also to walk through the process I used to develop it. He had a Power BI report using the Gantt chart custom visual however when he used a date slicer to select a date range it was only showing events which started on that date range and he wanted to see any events that were in progress for that date range. I had a colleague approach me at work with an interesting problem.
0 kommentar(er)
