cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fdelpre
Regular Visitor

Display a chart showing 2 different dates on one axis

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!

1 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.

 

 

 

 

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

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.

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).

fdelpre_0-1638100663273.png

 

I would like to make a chart like this:

fdelpre_1-1638100783910.png

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.

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.

 

 

 

 

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors