Hi all,
What is the best approach to create a waterfall like this in powerbi? I have no issues preparing it in excel but it won't load in powerbi.
Glad to get advise.
Data included below;
Area/Goal Original Save Spend
2020 Targets 64.0
2021 Target 58.8
Train 1 58.8 3.8
Train 2 62.6 2.0
Train 3 64.6 1.1
Train 4 65.7 1.0
Train 5 66.7 1.0
Train 6 67.7 0.4
Train 7 68.1 0.5
Train 8 68.6 4.1
Option 1 72.8
Train 9 69.9 2.9
Train 10 67.3 2.6
Train 11 64.7 2.6
Train 12 63.6 1.1
Train 13 63.1 0.5
Train 14 62.9 0.2
Option 2 62.9
Train 3 61.8 1.1
Train 4 60.8 1.0
Train 5 59.8 1.0
Train 6 59.4 0.4
Train 7 58.9 0.5
Option 3 58.9
2022 Targets 62.4 4.00
What is the best approach to create a waterfall like this in powerbi? I have no issues preparing it in excel but it won't load in powerbi.
Glad to get advise.
Data included below;
Area/Goal Original Save Spend
2020 Targets 64.0
2021 Target 58.8
Train 1 58.8 3.8
Train 2 62.6 2.0
Train 3 64.6 1.1
Train 4 65.7 1.0
Train 5 66.7 1.0
Train 6 67.7 0.4
Train 7 68.1 0.5
Train 8 68.6 4.1
Option 1 72.8
Train 9 69.9 2.9
Train 10 67.3 2.6
Train 11 64.7 2.6
Train 12 63.6 1.1
Train 13 63.1 0.5
Train 14 62.9 0.2
Option 2 62.9
Train 3 61.8 1.1
Train 4 60.8 1.0
Train 5 59.8 1.0
Train 6 59.4 0.4
Train 7 58.9 0.5
Option 3 58.9
2022 Targets 62.4 4.00