Scatter chart or Clustering chart

[Selwynster]

Not sure if this is possible, but I would like to place Dates on the x axis with Occurrences of an event on the y axis.

So if the event occurred on that date, it would be marked on the graph by a dot or a 1.

Please point me in the right direction.

[v-shex-msft]

HI @Selwynster,

Hmm, I guess your table contains events with occurrences date range who described by two date column, right?

If that is a case, power bi not support analysis date range generate by two date columns.

In my opinion, you need a to create expand date table with detail date to create visual. Please refer to below link to know how to do it.

Spread revenue across period based on start and end date, slice and dase this using different dates...

Regards,

Xiaoxin Sheng

[Selwynster]

Hi @v-shex-msft

Below is a small sample of my very long table.

I have all the Dates i need in this table. Do i need to split the table out?

Date	Event
1/1/2018	A
1/1/2018	B
1/1/2018	C
1/2/2018	A
1/2/2018	B
1/2/2018	C
1/2/2018	D
1/3/2018	A
1/3/2018	B
1/4/2018	C
1/4/2018	D
1/4/2018	E
1/4/2018	F
1/5/2018	D

[v-shex-msft]

HI @Selwynster,

Your table not need to be transformed, you can direct use it to achieve your requirement. 

Drag date to axis and switch to normal date mode, event column to value field with summary mode count.

Notice: scatter chart seems not support to use data column on x-axis.

Regards,

Xiaoxin Sheng

[Selwynster]

Thanks @v-shex-msft

But i need it on a Scatter or clustering chart

[v-shex-msft]

Hi @Selwynster,

Which visuals you want to use? I already create graph on a clustering chart. For scatter, it seems like date type not available on axis.

Regards,
Xiaoxin Sheng