Waterfall Demand History Visualization

Hey there,

Thanks for your checking.  See below table. We have different versions of forecast which is based on which month we made the forecast. For example, V1 forecast is the forecast we made in Jan. Given that, everything was forecast from Jan thru Dec. V2 forecast is the forecast we made in Feb, but we actualized Jan as true ship. Same methldology, V3 forecast is the forecast we made in Mar. the related Jan and Feb are the true ship.  To create below table in BI, we help the different audience to check ship vs forecast by different version (horizontally checking). So we will know what the forecast trend in the month by different version of forecast. For example, I highligted the actual ship in blue as below.  For A item, we finally shipped 78 units in Apr, but V1 Apr forecast Apr was 14, V2 Apr forecast was 91, V3 Apr forecast was 83 and V4 Apr forecast was 13. From those trend, we will know why our raw materials was overconsumed or underconsumed.  That's the purpose why we want to create that report in BI

But  the one I put everything in BI table format, it shows below. And In that table, month cannot be sorted, even I add a conditional column from 1 to 12, to try to sorted the month in the table, but still cannot. It shows different SKUs by the same month, (see below)