DENEB Time Location Chart - Missing bars

[brooks65]

Hi,
I have developed a stacked Gantt Chart using Deneb, however on review I found the chart is missing some activity information.

The first image represents the outcome of the code.

The second image highlights the issue. The Dates table and Gantt chart indicate data that is not represented in the Deneb chart.

Deneb Problem.pbix (10.9 MB)
Appreciate if you could help me.
Thanks

2023-12-06T20:00:00Z

[Greg]

Hi @brooks65.

I don’t on the surface see anything wrong with your Deneb/Vega-Lite code, but do see a data issue:
- when a task/subtask is selected (e.g., TB #3/TB#3-2) that has a positive difference in days between the start and finish dates, the bars display correctly
- when a task/subtask is selected (e.g., TB #3/TB#3-1) that has a zero difference in days between the start and finish dates, the bars do not display
Although both of these selections result in 546 records, I’m guessing Deneb automatically filters-out those with zero duration, hence no display.

Note 1: Your [DatesTable] table was not marked as a date table, so I updated it accordingly before creating a check measure:

Days Difference between startM & finishM = 
	DATEDIFF( [startM], [finishM], DAY )

Note 2: To maintain a constant Y axis interval, you can add a “scale” block with a “domain” 2-value array to the Y axis block, e.g.,

  "scale": {
	"domain": [
	  "2024-01-01T00:00:01",
	  "2024-12-31T23:59:59"
	]
  }

Hope this helps.
Greg
eDNA Forum - Deneb Time Location Chart.pbix (10.9 MB)

[brooks65]

Hi Greg,

Thanks for highlighting the problem. The issue was some of the duration interval in the Excel were 0.5 days which was converted to Zero duration when imported to PowerBI. I have now amended this duration to read as 1 day.

Further I have amended the Finish Date measure as Start + Av Duration. The graphs works as required.
Again thanks for the suggested amendments in the code line for constant Y axis. It reads better. Much Appreciated.