Forum Discussion
Helper ILine Chart - is it possible to display dates that have multiple values
I am trying to create a timeline for my team with tasks that need done on certain dates. The date look likes this, the attribute usually has a name as well
I would like this is a line chart with all the dates marked as a datapoint, however the ones that have multiple tasks on the same date are only showing 1 of the records for that date as ive had to use Min on the y-axis, Is there a way to get all the datapoints on the line chart
7 Replies
- bhanu_gautam
Super User
Kerslaing Add a new column with a formula that combines the date and the index to create a unique identifier.
UniqueID = CONCATENATE([Date], "-", [Index])Go to the "Report" view.
Add a scatter chart to your report.
Drag the "Date" field to the x-axis.
Drag the "UniqueID" field to the y-axis.
Optionally, you can add the "Attribute" field to the "Details" or "Legend" to differentiate between tasks.Click on the x-axis in the scatter chart.
Set the x-axis type to "Continuous" to ensure all dates are displayed correctly.
Kerslaingthanks for the quick response, but I cant add the unique ID to the y-axis as it is only allowing numbers in the y-axis because the x-axis is a date
v-echaithraCommunity Support
Hi Kerslaing ,
Thanks for your reply.y-axis in a scatter chart requires numeric values, so using a text-based UniqueID like "2025-05-29-1" won't work directly. But we can work around this with a numeric placeholder for stacking multiple tasks on the same date.
Try this approach:
Add an Index per Date
Use Power Query to group by Date and assign an index to each task on that date, This gives you a numeric column TaskIndex, restarting from 1 for each date.:
let
Source = YourTableNameHere,
Grouped = Table.Group(Source, {"Date"}, {
{"AllRows", each Table.AddIndexColumn(_, "TaskIndex", 1, 1, Int64.Type)}
}),
Expanded = Table.ExpandTableColumn(Grouped, "AllRows", {"TaskIndex", "Attribute", "OtherColumnsIfNeeded"})
in
Expanded
If you want to spread the points more visually instead of flat stacking, you can create a calculated column, that makes each task point slightly higher than the last on the same date.
YValue = [TaskIndex] * 0.2
Now Create the Scatter Chart
X-Axis: Date, set to Continuous under axis settings
Y-Axis: YValue or TaskIndex directly
Details or Legend: Attribute to distinguish tasks
Tooltips: Add any relevant fields e.g., task name, file name, etc.
If this issue has been resolved, consider accepting helpful replies as solutions.
Regards,
Chaithra E.- v-echaithra
Hi Kerslaing ,
We would like to follow up to see if the solution provided by us resolved your issue. Please let us know if you need any further assistance.
If our response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Regards,
Chaithra. - v-echaithra
Hi Kerslaing ,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Regards,
Chaithra E- Kerslaing
not had a chance to check this out yet, will try in the next couple of weeks
- v-echaithra
Hi Kerslaing ,
Thank you for the update, please try the solution provided, if the solution provided by us resolved your issue. Please let us know if you need any further assistance.
If our response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Regards,
Chaithra.
