Forum Discussion
Solved
Dynamic Forecast Comparison
Hi, The table below shows a summary of the data I'm working with. Each row represents a different production forecast for a given year. If I select a Year in the slicer, I want to display a wat...
GBilger what you can do is calculate a dynamic measure that returns the delta between the forecasts, so as to pass them directly into the chart and thus remove the subtotals, like this:
The graph above is the original one, in the one below I passed the DELTA measure as a value, calculated as follows:
DELTA = CALCULATE(SUM(Tabella[Volume]), ALLSELECTED(Tabella[Production Date ])) - CALCULATE(SUM(Tabella[PREV_VOLUME]), ALLSELECTED(Tabella[PREV_DATE]))where PREV_VOLUME and PREV_DATE are two calculated columns:PREV_DATE = LOOKUPVALUE(Tabella[Production Date ],Tabella[Indice],Tabella[Indice]-1)PREV_DATE = LOOKUPVALUE(Tabella[Production Date ],Tabella[Indice],Tabella[Indice]-1)instead Index is a column that you can insert from the power query in the sorting you prefer to give to the data to calculate the differential.I hope I was clear, let me know,B.
GBilger Hi!
You can calculate an empty column like: Column= "" and put this new Column in the Breakdown field of the Waterfall Chart.
B.
Hi,
The proposed solution did get rid of the labels for the increases/decreases. However I was curious if there is a way to get rid of subtotal bars in between. For this example it would just show the 2019 LRP and Actuals bars. In between would be all the differences.