Ok, what I was able to achieve now is that I have a difference Gantt Walk/Waterfall, splitted by group, in a timeframe defined by two parameters start and end:
That is already close to what I wanted.
My question now would be if it is somehow possible to get the YEAR(Start) and YEAR(End) at the beginning and end of the columns (part of Evaluation Group). So that I basically have a waterfall/walk from year to year by Evaluation Group. Right now, I did a custom check for FIRST() and LAST() inside the differences measure to fill these up, why G1 and G10 are filled, even if they make no positive/negative difference.
Is this somehow possible?
Thanks a lot in advance
could you please share your sample workbook , to achieve Start year and end year you can create separate workbook and use in dashboard to display year and you can hide the g1 to g10 display.
I will try to build a sample book, but the data is based on multiple confidential files blended, which I cannot publish in any way. I have to make some time to recreate that in a meaningful way to create the example.
For the graph: I don't want to hide anything at all. In one chart there should be:
Y2014 G1 G2 G3 ... G10 Y2017
Whereas the years are full bars, while the groups are differences. This is case I am required to recreate.
Thanks a lot