Waterfall Chart Help

Hi manah77g ,

I failed to meet all of your requirements. Coloring the first column wasn't possible with the standard waterfall chart visual. But maybe you're still satisfied with my solution. I did the following:

1. Entering your table using "Enter data"
2. Switch to Power Query
   1. Removed the t from row 8
   2. Added an index column (a very important step to keep the category order)
   3. Changed type of "value" column to decimal number using context menu "using local..." and an appropriate region for your number format
   4. Removed your last row (the Power BI waterfall calculates its own total)
3. Closed Power Query
   1. Set Sortby Index of category column to index (a very important step to keep the category order)
   2. Set format of value to Decimal number and adapt the details like the number of decimal places
   3. Add a waterfall visual
   4. Add "category" to Category
   5. Add "value" to value.
   6. Check an appropriate summarization setting for value (Min, Max, Sum should work)
   7. Adjust the setting of the waterfall chart:
      1. Columns->Colors: Adjust color of total column
   8. Add a textbox with "Actual NPAT" to cover the "Total" string

Find attached a pbix Demo!

Hope that helps and meets at least the most of your requirements!

Dear manah77g,

I'm glad if I could help.

It might be interesting for you to have a look at a custom waterfall visual:

1. https://marketplace.microsoft.com/en-us/product/power-bi-visuals/WA200000195?src=office&tab=Overview
   1. It's free
   2. First and last column may have a different color but not dynamically
2. Or a more sophistcated one: https://inforiver.com/analytics-plus/waterfall-chart/
   1. Not free
   2. You can adjust almost everything

But I have no experience with one of these custom visuals.