Line Chart with Date Value Y-Axis

[DavidNash]

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.

[Anonymous]

Hi David,

i am look for a way to have Date on y axis

Did you find that ? 

Thanks

[DavidNash]

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.

[SteveCampbell]

Could you provide an example (picture) of what you're trying to achieve? I'm still a bit confused at the conecpt.

[DavidNash]

[jthomson]

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

[jthomson]

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

[DavidNash]

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.

[v-yulgu-msft]

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

[SteveCampbell]

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.