2 values in x-axis

[Jiro]

hi all,

I have 2 queries. One is for export shipment from 8 warehouses. Another one is import shipment into 3 warehouses. Export and import cannot be merged into single table.

How can I use 2 date series (ETD and ETA) values into x-axis, so I know that in a specific date we have how many import and export?

Main datapoints:
- export order number
- warehouses
- estimated time of departure

Main datapoints
- Import order number
- warehouses
- estimated time of arrival

[TomMartens · Accepted solution]

Hey @Jiro ,

create a dedicated calendar table, Create two relationships from the Calendar table on the 1-side of the relationship and the ETA and ETD on the many-side of the relationship. This is what dimensional modeling is all about. Get an introduction to dimensional modeling here: https://learn.microsoft.com/en-us/power-bi/guidance/star-schema?WT.mc_id=DP-MVP-5003068

Then use the date column from the Calendar table on the x-axis and drag the "Import order number" and "Export order number" to the values bucket of the data visualization, make sure that you change the aggregation function to Count - Done!

Here you will find an example on how to create a Calendar table: https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/

Hopefully, this provides what you are looking for.

Regards,

Tom