Forum Discussion
Make bubble chart display time by day
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.
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
9 Replies
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!
I did say that the column is set to date. I can't post the data, but I may be able to manage screenshots.
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.
