Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@HamidBee , I am able to see DateTime on x-axis and Count of ID on Y. You need other parameters to me it works
If you read the question I am specifically looking for Time only along the x axis. Not Date/Time.
@HamidBee , I doubt you can do it without using a new time column.
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |