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!!
Impactful IndividualThank 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.
Resolver IThankyou, 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 visual
Would 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- Hakuna_matata
You’re right colors in the waterfall visual are currently assigned only to increase, decrease, total, and other categories, not to individual measures. There isn’t a dynamic option for this, colors can only be set manually for those four characteristics. But you might consider creating a similar effect using a Stacked Column Chart or exploring a custom visual.
PBIX file link: TestFilelink_here
Reference to custom option:
https://community.fabric.microsoft.com/t5/Desktop/Stacked-Waterfall-Chart/td-p/3708142
Hope it help! Thank you ^_^