Recreate Line Chart from Excel in PowerBI

[Anonymous]

I am able to create this graph quite easily in Excel.  

I am able to recreate the same table in Power BI however when I convert the table to a line graph, Power BI does something I can't wrap my head around. 

How do I recreate the line chart from the Excel screen shot in PowerBI?

[jshutters]

After looking at your screen shots, it appears your X-axis is different.  In Power BI, try switching your x-axis field with the legend.

[Anonymous · Accepted solution]

I figured it out. You have to format the data like this:

Then PowerBI will accept the #Timestamp in the legend field.

[Anonymous]

Power BI will not allow me to drop my X-axis (Comment ID) into the Legend field. 

I'm not sure why. I assume it has to do with what type of data it is? I don't get an error, Power BI just refuses to accept the new Legend.