Bar graph shows duplicate datetime in xaxis

[Anonymous]

I am actuaaly stuck in a problem in power bi report where datetime value is not appearing correct. Attached is sample data.Value,DateTime
0.0068,2020-03-29 00:00:00
0.00896,2020-03-29 01:00:00
0.00992,2020-03-29 02:00:00
0.00812,2020-03-29 03:00:00
0.00732,2020-03-29 04:00:00
0.00624,2020-03-29 05:00:00
0.00528,2020-03-29 06:00:00

 
you can see here that in graph 29/3 1:00 shows two points and one is empty though it should appear as 2:00 as in the table below. Anyone has any idea how to fix this problem. Its a datetime datatype and i cannot change it to text or spilt the columns in date and time seperate columns and then show in graph.

Regards

Shilpi


 

[PhilipTreacy]

Hi @Anonymous 

Download sample PBIX file

I don't have the same issue with the sample data you posted

Can you please share your PBIX file.

Regards

Phil

[Anonymous]

Hi i triedyour file and to me it appears the same missing datapoints

[PhilipTreacy]

Hi @Anonymous 

The image you've shown, the missing column is at 1.00am but the 2nd column is also at 1.00am?

My chart has columns at 12, 1, 2, 3 am etc.

How can the data have changed if you are looking at the same file/chart that I created?

Have you got any filters applied?

Can you please share your PBIX file.

regards

Phil