Forum Discussion

roscoegray's avatar
roscoegray
Frequent Visitor
9 years ago

Events in progress - Users logged in at anyone time - Query

Hi All,   New to Power Bi and struggling with a measure that i hope someone can help me with...   I have some user login and logout data, on separate tables and it repeat throughout the day, bit ...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi roscoegray,

 

You can create a DateTime[DateTime] contains date time value with 30 minutes interval, eg: 8/1/2017 1:00:00, 8/1/2017 1:30:00, 8/1/2017 2:00:00, etc. then drag this column to the line chart X- axis.

 

Best Regards,
QiuyunYu

eugee123's avatar
eugee123
New Member
5 years ago

May I know how to create a date time table with 30 mins or even 1 min interval? This is what i require to solve my PowerBI problem.

 

Thanks!