Forum Discussion
Plotting times on a graph
- 10 years ago
Starting from a single Date column, I would follow these steps:
- Using Power Bi Designer: Home / Edit Queries / select your Query
- Add a "Date" column - select your Date column, Add Column / Date / Date only
- Add an "Hour" column - select your Date column, Add Column / Time / Hour
- Add an "Minute" column - select your Date column, Add Column / Time / Minute
- calculate a "Hour Decimal" column in the Query Layer - Add Column / Add Custom Column / Hour Decimal = [Hour] + ( [Minute] / 60 ). So 3:15pm would become 15.25.
- Set the data type of the new "Hour Decimal" column - Home / Data Type: Decimal Number
- Close & Apply
- Navigate to Data view, choose your table, choose the "Hour Decimal" column, navigate to Modeling and set Default Summarization: Minimum (depends on your requirements - this will show the first Time for each Day. You can customize this for each Visual).
- Navigate to the Report view, select your Line graph Visual, set the Axis to be the new "Date" field, and the Value to the new "Hour Decimal" field.
Now the Y-axis shows the Time portion of each date, from 0 - 24.
While figuring this out, I've built a working solution which you can download from my OneDrive and try out:
It's the file: Power BI demo - Line chart of date vs time.pibx
The data is a random sample but hopefully it helps show the steps.
I have a similar Issue. I have data with two colums and I want simple XY scatter plot. I want date on axis and 96 times stamps(24 hour with 15 min interval on Y axis).Two months date on x -axis and 96 time stamps on Y axis.Just need XY scatter plot as in Excel.I tried but with no luck in p.ower BI.Everytime I am trying to drag date and time am I getting only the aggregation.Its very important requirement for us.Appreciate help.Thank You