Forum Discussion
Impactful IndividualWaterfall with different measures and different colours
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!!
Resolver IHi ^_^ lucadelicio , looks like an interesting use case!
Would you be able to share the file? It would really help to understand the problem statement more clearly. I do think a parameter might work in this case, but I can't be completely sure without seeing more details.
To better understand your setup, it would be helpful to know:
What the support table looks like (e.g., column names and a few sample rows),
How the SWITCH measure is currently written (a sample of the DAX you're using),
How you're triggering the selection of values—is it static, slicer-driven, or using some other logic?
lucadelicioThank you for interesting and help me.
Here the pbix file of example, tell me if you need more information.
I think the file will answer to your question.- Hakuna_matata
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!!
- lucadelicio
I do not undestand, how you can choose different colours for different measures? It seems colour change for Increase, Decrease and Total and not for the specific measures.
Can you upload the pbix file please? Thank you