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
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!