Forum Discussion

DavidNash's avatar
DavidNash
Regular Visitor
8 years ago

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.
DavidNash's avatar
DavidNash
Regular Visitor
8 years ago

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.

jthomson's avatar
jthomson
Icon for Solution Sage rankSolution Sage
8 years ago

Could you not try to extract the day from your date and convert that to a number?

  • DavidNash's avatar
    DavidNash
    Regular Visitor
    8 years ago

    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.