Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Here is a sample of the data that I am working with:
| ID | Entry Date |
| 1 | 2021/08/23 08:41:00 |
| 2 | 2021/08/23 11:52:00 |
| 3 | 2021/08/23 11:53:00 |
| 4 | 2021/08/23 12:15:00 |
| 5 | 2021/08/23 12:43:00 |
| 6 | 2021/08/23 16:53:00 |
| 7 | 2021/08/23 17:12:00 |
| 8 | 2021/08/24 14:45:00 |
| 9 | 2021/08/24 16:35:00 |
| 10 | 2021/08/24 17:04:00 |
| 11 | 2021/08/25 08:26:00 |
| 12 | 2021/08/26 08:46:00 |
| 13 | 2021/08/26 09:17:00 |
| 14 | 2021/08/26 15:05:00 |
| 15 | 2021/08/26 16:04:00 |
| 16 | 2021/08/28 11:45:00 |
It shows the times that people entered a particular location. I'd like to create a scatter chart with a play axis that shows the count of people entering at particular times. So I'd like 'Count of people' to be along the y-axis and 'Time' to be along the x axis.
I'm trying to find a way to change the data type to 'Time' instead of 'Date/Time' without creating a new column or editing an existing column. Is it possible to create a DAX measure for this?. Does anyone have any ideas?.
Please find attached the sample file below:
https://www.mediafire.com/file/r4ssmp2zmcfecbq/Sample_Data_Count.pbix/file
Thank you,
Solved! Go to Solution.
@HamidBee You need to create a new column which only extract the Time.
@HamidBee You need to create a new column which only extract the Time.
If you read the question I am specifically looking for Time only along the x axis. Not Date/Time.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!