Make bubble chart display time by day

[ChrisHamp]

Hello all. I have a set of data with a date, lat, long, and value. I can put that data on to an ArcGIS map to display as a bubble chart, and have the display change as the date changes, but the time slices are some weird values like 16h33m. The timeline slider won't let me change to 24h. Since my data is by day, this leads to blank time periods. My import data is formatted date, the Power BI column is date, so I have no idea where this time value is coming from.

[Royel]

Hi @ChrisHamp  you need to ensure your Date column has Data Type Date not Date/Time 

Steps: Click Data View -> Select Date Column -> Change Data Type as Date 

If, it not solved, share screenshot of your data, and visuals. If possible upload your sample power bi file in google drive and share direct access link, you will get faster solution. 

Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!

[ChrisHamp]

I did say that the column is set to date. I can't post the data, but I may be able to manage screenshots.

[ChrisHamp]

I think the problem may come from ArcGIS. There are time settings there, but only if the data is in a layer. My guess is that some default settings are coming through that can't be changed in Power BI. A pity because I like that visualisation.

[Royel]

Is it possible to share the pbix file with just few rows like 2. It will be quick fix. even you can delete  other tables. 

[ChrisHamp]

Unfortunately not. The ArcGIS map comes from an internal server that you don't have access to. I don't think there's a way to include it it in a pbix file.

[v-aatheeque · Accepted solution]

Hi @ChrisHamp 

Thanks for clarifying. Since the ArcGIS map is hosted on an internal server, we won’t be able to access it directly. However, to help us reproduce the scenario follow the below 

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

[v-aatheeque]

Hi @ChrisHamp 

To help us reproduce and troubleshoot your scenario, we requested to share a small sample dataset/file. Could you please provide that when convenient?
It will allow us to give you a more accurate and tailored solution.

[v-aatheeque]

Hi @ChrisHamp 

To better reproduce and troubleshoot your scenario, we kindly request a small sample dataset/file. Please share it at your convenience, as this will help us provide a more accurate and tailored solution.

[v-aatheeque]

Hi @ChrisHamp 

To help us reproduce and troubleshoot your scenario, we requested to share a small sample dataset/file. Could you please provide that when convenient?
It will allow us to give you a more accurate and tailored solution.