Waterfall with different measures and different colours

[lucadelicio]

Hi everybody,
i need for a porting from another bi system to create a waterfall like the folowing image.

The columns rappresent different measures with different method of calculation.
I need to select different colours for different measures and total.

I arrived to this solution after create a support table and a specific measure to switch (and i'm shocked that i had to do it for an easy waterfall).

How can i choose the colour for the different measures?
I have to create other 20 waterfall if for every i have to do all this i think is crazy.There is an easy way to re-create the waterfall?
Thank you very much.
Every suggest is appreciated.

[v-echaithra]

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.

[v-echaithra]

Hi @lucadelicio ,

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.

[v-echaithra]

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.

[Hakuna_matata]

Hi ^_^ @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?

[lucadelicio]

Thank 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 · Accepted solution]

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 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 ^_^