To many dates displayed when there should only be two (in this example)

[brightbright]

Hi 

I'm using Excel which is connected to SharePoint. 

I have two columns in the Excel file, one for data and the other for the value I'm tracking. 

You'll notice from the screenshot that the dates are at the end of the week. 

When I visualize the data in Power BI Service the end date is displayed but all of the dates between are also displayed. 

How can I fix this?

 

 

[brightbright]

@GilbertQ thank you so much. Removing the extra blank columns did the trick. 

[GilbertQ · Accepted solution]

Hi @brightbright 

That typically occurs because you only have got two date values So it is appears to be wrong. And once you have more dates, it should then only show you the data that you have. also make sure to remove any blank columns when importing your exile file.