Forum Discussion
waterfall chart
Doesn't work
- saud9681 year agoMemorable Member
Try this
Create a Custom Column for Colors:
In your data model, create a custom column that assigns a unique color to each category. You can use a DAX formula to define this column.
CategoryColor =
SWITCH(
TRUE(),
[Category] = "Category1", "#FF5733", // Red
[Category] = "Category2", "#33FF57", // Green
[Category] = "Category3", "#3357FF", // Blue
// Add more categories and colors as needed
"#000000" // Default color (black)
)Add the Custom Column to Your Waterfall Chart:
Add your data to the waterfall chart as usual.
Drag the CategoryColor column to the Legend field well of the waterfall chart.
Format the Waterfall Chart:
Go to the Format pane.
Under Data colors, set the colors for each category based on the CategoryColor column.
Adjust the Chart Settings:
Ensure that the Sentiment option is turned off in the Format pane. This will allow you to use the custom colors instead of the default increase/decrease colors.
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!- Anonymous1 year agoNot applicable
there is no legend section in waterfall chart
- saud9681 year agoMemorable Member
you can use the Data colors option in the Format pane to manually set the colors for each category.
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!