scatter chart with dates and intervals

[uwmarkyo]

Hi

I have a table like this:

I would like to convert it to scatter chart like this:

I use Power BI, and put dates on x Axis and time on values or Legend. It always shows errors. I tried to put interval on y Axis, but it wouldn't move.

can someone teach me how to create this chart?


Thanks,

 

[SullyWYO]

I think your problem is that you are trying to use the "Interval" column as your Y axis. That won't work - you need to let the chart establish the y axis (time), based on the data in the table.

If you remove the "Interval" column from your table, this will be easier (see example below). Be sure that the data types for each column are correct (date / time). You can play with the axis formatting to get the times on the axis to reflect what you want (use the "bounds" options). When you format the X axis for the dates, be sure to set Units > Major to 1.0 so that you won't get multiple entries for each day.

 

[uwmarkyo]

I think your problem is that you are trying to use the "Interval" column as your Y axis. That won't work - you need to let the chart establish the y axis (time), based on the data in the table.

If you remove the "Interval" column from your table, this will be easier (see example below). Be sure that the data types for each column are correct (date / time). You can play with the axis formatting to get the times on the axis to reflect what you want (use the "bounds" options). When you format the X axis for the dates, be sure to set Units > Major to 1.0 so that you won't get multiple entries for each day.

Thanks for the clear instruction. This helps me learn a lot