Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
HamidBee
Impactful Individual
Impactful Individual

How do I show Time only along the X axis and Count on the Y axis?

Here is a sample of the data that I am working with:

IDEntry Date
12021/08/23 08:41:00
22021/08/23 11:52:00
32021/08/23 11:53:00
42021/08/23 12:15:00
52021/08/23 12:43:00
62021/08/23 16:53:00
72021/08/23 17:12:00
82021/08/24 14:45:00
92021/08/24 16:35:00
102021/08/24 17:04:00
112021/08/25 08:26:00
122021/08/26 08:46:00
132021/08/26 09:17:00
142021/08/26 15:05:00
152021/08/26 16:04:00
162021/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,

1 ACCEPTED SOLUTION
Tahreem24
Super User
Super User

@HamidBee You need to create a new column which only extract the Time.

Time Column = FORMAT(TableName[Entry Date],"Long Time")
Then take this column on X-axis and your numeric column on Y axis of line or chart visual.
Capture.JPG
 
 
Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard

View solution in original post

4 REPLIES 4
Tahreem24
Super User
Super User

@HamidBee You need to create a new column which only extract the Time.

Time Column = FORMAT(TableName[Entry Date],"Long Time")
Then take this column on X-axis and your numeric column on Y axis of line or chart visual.
Capture.JPG
 
 
Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Please take a quick glance at newly created dashboards : Restaurant Management Dashboard , HR Analytics Report , Hotel Management Report, Sales Analysis Report , Fortune 500 Companies Analysis , Revenue Tracking Dashboard
amitchandak
Super User
Super User

@HamidBee , I am able to see DateTime on x-axis and Count of ID on Y. You need other parameters to me it works

 

amitchandak_0-1648470425689.png

 

 

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.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.