- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Line chart X-axis. Continous by Date (DD/MM) and time (HH:MM)
I have struggled to find a solution to problem with X-axis on a line chart.
I have some climate data with 10 minutes resolution. I want a line chart with up to 7 days historical data. I have a column in the query with Date/Time, e.g. 10/05/2025 10:00. If I use this column as X-axis I can only chose from year, quarter, month, day but not time. I have managed (with my limited skills) to separate the Date/time column in one column with date and one column with time. These columns are formatted as Date and Time. But if I use these two columns as X-axis I cannot choose Continous.
I can use the Time column as X-axis, as Continous. But then I can only use the timer from midnight as historical data. If I choose 24 hours or e.g. 2 days the data values will be summed or averaged for the time points.
Current line chart:
Name of date column (With date (dd/mm/yyyy and time): Date
Name of "short date" column: dd/mm
Name of Time column: Time
How I would like the X-axis to look like:
00:00 00:10 00:20 ............................ 00:00 00:10 00:20 ................. 00:00 00:10 00:20
08/05 09/05 10/05
I prefer to not have a scroll bar on the X-axis, hence the X-axis must be continous.
/Martin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for your patience Ibendlin.
New link:
https://drive.google.com/file/d/1jXySheFrKEtmCYLuhZdW3j7HEQBBX6FR/view?usp=drive_link
In the above I have used "Time" column as X-axis. Time is the time from the "Date"-column which comntains date and time. With "Time" I can select Continous x-axis. If I select "date" I cannot select continous. The date-column is formated as date/time.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for your patience Ibendlin.
https://drive.google.com/file/d/1jXySheFrKEtmCYLuhZdW3j7HEQBBX6FR/view?usp=sharing
In the above I have chosen "Time" as X-axis. Time is the time from the "Date" column. I can select "Continous" when Time is selcted. But when I select "Date" I cannot select continous. The Date column is formatted as Date/Time
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You should be able to use the original datetime field on the X axis as is.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you Ibendlin for the instructions.
Link to pbix-file
https://drive.google.com/file/d/1BSxr490phnHu2x6Csd05ZZ2lWAqKu2sJ/view?usp=drive_link
Link to datafile
https://drive.google.com/file/d/142QbMqhq3p9aZDMxsnFYOr7djdiRhaoo/view?usp=drive_link
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Both links require access. Please check.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for your patience
I ask like this:
I have a data table with climate data (temperature etc.). The resolution is 10 minutes. I want to make a visual (line chart) with all the data visualised for a time period of 5 days. All the data points must be show - not summarised or averaged. Hence, the x-axis must be continous.
In the query I have a column named "Date". The column is formatted as Date/time. This column contains date and time, dd-mm-yy hh:mm:ss
I have duplicated this column and transformed it to time only. This column is named "Time" and formatted as Time.
If I choose "Date" as my X-axis, I cannot select continous (not shown). I only get a summarised or average value per day.
If I chose "Time" as my x-axis, I can choose continous and data for each 10 minutes is shown individually. But if I select more than the last 24 hours, the values per timestamp will be summarised or averaged.
If I choose "Date" and only Day from the hierachy and add "Time" to the x-axis, again I cannot select continous.
pbix
https://drive.google.com/file/d/1jXySheFrKEtmCYLuhZdW3j7HEQBBX6FR/view?usp=drive_link
CSV datafile
https://drive.google.com/file/d/1Px8Yd2Z4dvUcXLzHLZz9Eo5HdeSoq6rR/view?usp=drive_link
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
01-04-2024 03:43 AM | |||
07-08-2024 12:46 AM | |||
07-12-2024 02:32 PM | |||
07-12-2024 06:18 AM | |||
12-01-2022 03:11 AM |
User | Count |
---|---|
122 | |
79 | |
58 | |
58 | |
44 |
User | Count |
---|---|
179 | |
120 | |
82 | |
70 | |
53 |