Forum Discussion
Show different date dimension on two axis
What you can do is:
1. In order table, merge to Conversion_Date table to get the new PromisedShipDate.Date, which is a DateTime format column;Merge to Conversion_Date table again to get the new ActualShipDate.Date
2. add columns in the Order table with Name : [Feb-19], [Mrt-19],[Apr-19] etc, the Power Query M language script will be like = if Date.Month([ActualShipDate.Date]) = 2 then [Quantity] else 0.
3. create a table in report view with columns you need.
Thanks for thinking along parry2k
I have two measures that give the shipped quantity by contract month and also by ship date - that works.
however I would like to see the X-axis show the contract monht, and the Y-axis show the shipment date... that's not working with the measures..
What this gives:
What I'm looking for is this:
(the blank contract month is dec16 which is excluded from the data).
ps. I've merged the two date dimension tables (the second one had additional information) - indeed it was overcomplicating the model - thanks!
Super UserAnonymous i'm not fully sue what you mean, when the quantity is blank it is not going to show the month, may be i'm missing something here.
I see it's a bit confusing parry2k ... in this concrete example there's one order placed on 10th of January, which is allocated to contracts from dec/jan/feb/mar.
I would like to see the order number and the order date (10th of Jan) in one row as headers, and the contract allocation in the column headers.
All the dates are in the whacky format so I can't just add the column from the source table..
Does that clarify?