Display a chart showing 2 different dates on one axis

[fdelpre]

Hi, I'm new to Power BI. Can you help me understand how to make a chart containing 2 different dates on one axis (for example y axis) and the supplier on the other (for example x axis)?

The aim is to insert 2 data tables: 1 for the declared dates, 1 for the actual delivery dates. So you can quickly see the suppliers who have not met the delivery date.

Do you think it makes sense? Do you have any other suggestions?

Thanks for your help!

[lbendlin]

You can have multiple Y axis series, but it's not clear how you would want to visualize this.

Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.

[fdelpre]

Thanks for the reply, I try to explain better.

I have these two tables which contain three columns: increasing number, product, declared date / effective date. So the two tables differ only for the third column (declared date / effective date).

I would like to make a chart like this:

where on the x axis there is the date and on the y axis there is the product. I would obtaine two line: the line obtanied by crossing the product and the declared date and the line obtanied by crossing the product and the effective data, on this graph.

[lbendlin · Accepted solution]

Add a calendar dimension table to your data model 

Make a connection from the calendar to the declared date fact table and to the effective date fact table 

Use the calendar date as the x axis 

Add your values to the y axis.

Your sample data is unsuitable for representation in a line chart.