Forum Discussion
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!
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.
3 Replies
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).
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.
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.
