Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

waterfall chart

Can we create a waterfall chart like this in Power BI Like by default we just get Increase/Decrease in waterfall chart in two colours, but here we need to show each bars in different color for...
Need Help
saud968's avatar
saud968
Memorable Member
1 year ago

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!

Anonymous's avatar
Anonymous
Not applicable
1 year ago

there is no legend section in waterfall chart

  • saud968's avatar
    saud968
    Memorable Member
    1 year ago

    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!

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      which version of PBI are you using? you are getting unrealistic options.

      Please try and test first before suggesting solutions

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi Anonymous ,
        If you need to display each bar in a different color for each category, I suggest you try using the simple waterfall visual object, where you can set 'Format using Sentiments' to off and then customize the bar colors.

         

        Here is the link about simple waterfall, Simple Waterfall,if you still have more recent questions, you can feel free to contact me, I will receive your message after the first time to reply to you, if my program can solve your problem I will be very grateful!

        Hope it helps!

        Best regards,
        Community Support Team_ Tom Shen

        If this post helps then please consider Accept it as the solution to help the other members find it more quickly.