Desktop report hiding/removing time series entries from MS access DB

[Anonymous]

Hello guys,

I'm trying to visualuse some timeseries data, wich comes from a MS access database using access 2007-2016 file format (office 365 package). In this database, I have a full year of data, with a value at every hour of the year, of which I have multiple time series. I want to make every hour a bar in a bar-type chart, such as displayed below:

Wanted result: an entry for every hour

This works very well as long as I am zoomed in a lot on the data. Whenever I start to zoom out more, entries start to disappear, even though I know that they are present in the database. The screenshot below is the same time window as above, but extended by one day on both sides. 

Strange: entries are missing, even though I know they exist

When I zoom out even more, it doesn't even seem to matter how many days I have selected, there is always the same number of entries/bars visible in my graph

Somehow this has something to do with the number of entries (they are quite a lot). There is the message "Showing a representative sample", which states that there are too many entries. But I know it SHOULD be possible to get all entries to be visible, since I have seen it before.

Thanks in advance for your help!

[v-shex-msft · Accepted solution]

Hi @Anonymous ,

Current power bi not support analytics date and time part from one field at same time.

I'd like to suggest you split date and time to multiple columns, then drag them to axis field and drill to bottom level to display both date and time part.

BTW, you can also turn off concatenate label feature to see data label more clearly.

Regards,

Xiaoxin Sheng