Forum Discussion
Waterfall with different measures and different colours
- 1 year ago
Thankyou, I think field parameter might help. I have taken a data table such as
Date Category Metric Amount
01/01/2025
Start
Sales
100
02/01/2025
Sales
Sales
50
03/01/2025
Expenses
Expenses
-30
04/01/2025
Profit
Profit
20
05/01/2025
End
Sales
150
05/01/2025
End
Expenses
-30
05/01/2025
End
Profit
20
Created measures for metric
TotalExpenses =
CALCULATE(
SUM(DummyData_Pivoted[Amount]),
DummyData_Pivoted[Metric] = "Expenses"
)
Used the measures to create a field parameter and created the visualWould this help to get the result. ^_^ Hope it help!!
Hi lucadelicio
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithra.