Forum Discussion
PowerBI Chart w/Time
Can I use a PowerBI desktop visual to mimick the below?
My data source is an Excel workbook.
I need to have a visual that shows 'Time In' and 'Time Out', with the Legend being the days of the week.
I have 'Date' (Date ShortDate format), 'Time In' (Date ShortDate format), and 'Time Out' (Date ShortDate format) columns.
3 Replies
PhineasT Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.I'd like my PBI Desktop visual to mimick the below.
Here is an example of my dataset.
Being a neophyte, the best that I can achieve thus far is...
If there a reason why I can't see/use the time in 'Y' axis like the example?
Here's my attempt at this.
Created a dataset like this
Date TimeIn TimeOut 3/21/2023 8:05 10:02 3/21/2023 8:53 9:23 3/21/2023 9:12 9:15 3/21/2023 10:15 11:23 3/21/2023 10:24 15:45 3/21/2023 13:13 13:44 3/21/2023 13:40 15:23 3/21/2023 15:22 15:55 3/21/2023 16:15 16:44 3/21/2023 16:44 16:50
