Forum Discussion
2 values in x-axis
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
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
1 Reply
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