Forum Discussion
Line Chart with Date Value Y-Axis
I am trying to make a line shart with date values on the Y-Axis. Is there any way to do this? The current line shart only seems to allow numerical values to be shown.
9 Replies
Out of interest, why would you want date on the y-axis? What would be on the x-axis?
In a line graph the y is a values axis (the dependent axis), and shows the value of the X axis at a given point, so this would not make much sense.
Hi DavidNash,
For a chart visual, it is not able to add a date field into Y-axis, as you know, Y-axis allows numerical values only. Also, fields added to Y-axis will be aggregated by default.
Regards,
Yuliana Gu
I have an X axis that is categorical by Month. The Y axis needs to show dates to show how milestones are changing each month report to show a trend. It can be done in Excel so this is a much needed functionality in BI.
Could you not try to extract the day from your date and convert that to a number?
Yes that works but my client wants to see what the date is not only the trend. So it needs to be in date format.
Could you provide an example (picture) of what you're trying to achieve? I'm still a bit confused at the conecpt.
