cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cheese_Moose Visitor
Visitor

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

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:

BI-BS 1.PNGWanted 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. 

BI-BS 2.PNGStrange: 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

BI-BS 3.PNGBI-BS 4.PNG

 

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!

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

Hi @Cheese_Moose ,

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.

20.png21.png

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
1 REPLY 1
Community Support Team
Community Support Team

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

Hi @Cheese_Moose ,

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.

20.png21.png

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |