Forum Discussion
Line Chart with Date Value Y-Axis
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.
As a clunky workaround, maybe:
- create a column/measure that calculates the difference in days between the bottom value on the y-axis of the image you've posted
- use that figure as your y-axis value
- set your y-axis start/finish to fixed values
- then turn off the axis labels and use text boxes to label it as dates in the correct spots
Not ideal but I can't think of a better way round it right now
