Data in column diagram

[johnkorten]

Good morning,

I'm new on this forum and trying to build some power bi report for the company.

I have now a report what i can not figure it out to present the data correctly how i want it.

We are a company that buy liquid products in EU and load it by trucks and bring them into our tankstorage.

I want to build a report where it shows in a diagram  the planned loads against the received load

I have 2 tables:

1 with the planned loads(Quantity, ETA, etc)

1 with the delivered loads (Delivered weight, ETA, etc)

Can someone tell me what the best visual is to use for this and what data needs to be in what colums to get the visual correct.

[ctaulbee]

This question is best asked under the Desktop category.

In my opinion, simple is best. You could do well with a clustered column chart. You will need to create a date dimension table and define a relationship between that new dimension and the 2 fact tables you listed above. This will allow you to create a column chart to compare side-by-side the planned vs delivered loads by month.