chart with 2 x-axis

[schreima]

Hi there,

I'm having the following table as basis:

Date	amount of on-hand	Date End of Leadtime	amount end of leadtime
05.05.23	10	12.05.23	8
06.05.23	9	13.05.23	13
07.05.23	9	14.05.23	13
08.05.23	9	15.05.23	13
09.05.23	8	16.05.23	12
10.05.23	8	17.05.23	12
11.05.23	13	18.05.23	12
12.05.23	13	19.05.23	11

I would like to plot 2 line charts in one visual with their corresponding x-axis - so for line 1:  x-axis 1 =05.05.23, y-axis: 10, x-axis 2: 12.05.23, y-axis: 8, where x-axis are running synchron (meaning on 12.05. I can see on hand = 13, amount end of leadtime = 8

Do you have any idea how to realize that?

Thank you very much

[schreima]

Super, thanks a lot, that helped a lot

[HotChilli · Accepted solution]

I think you want to create a date table with 2 relationships to the 2 dates in your table(one will be active, one inactive).

Create a measure for the SUM of end of leadtime using USERELATIONSHIP.

Put the date from the date table on the x-axis of a line chart. Put Sum of amount on-hand in the y-axis. Put the measure on the secondary y-axis.

I think that's what you want.