Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi! I am using PostgreSQL data source and want to display data for the last 30 minutes onto a line chart. However, I am not sure why no data points can be seen.
I want to achieve something like this:
Thanks for reading!
Solved! Go to Solution.
If I had to guess it is going to be due to UTC. The best solution I can think of is to have a duplicate of your DateTime field but set to UTC. Do your filtering on the UTC column but use your localised date/time field used in the graph itself.
Power BI, especially in the Service, does everything using UTC datetime for the out of the box features.
Hi @efjw ,
Could you please show you a screenshot of your table data, I would like to know if there is time in your datetime column?
My Table View:
I did another test to include the time in my datetime and the display looks like this:
My Report View:
Best Regards,
Sunshine Gu
@Anonymous Thanks so much for replying! My table has a datetime column but I belive that it was the auto hierarchy that caused the issue! After turning off auto date/time and creating a new report, it works now!
If I had to guess it is going to be due to UTC. The best solution I can think of is to have a duplicate of your DateTime field but set to UTC. Do your filtering on the UTC column but use your localised date/time field used in the graph itself.
Power BI, especially in the Service, does everything using UTC datetime for the out of the box features.
User | Count |
---|---|
84 | |
77 | |
76 | |
43 | |
36 |
User | Count |
---|---|
109 | |
56 | |
52 | |
48 | |
43 |