Forum Discussion
Helper IIScatter chart or Clustering chart
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
SelwynsterHi Anonymous
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 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 Anonymous
But i need it on a Scatter or clustering chart