Waterfall Chart Help

[UK06B1]

Hello 

I am looking to replicate a waterfall chart in power BI, it is posisble in Excel. Bascially to make the 2 columns in this visual as totals. In excel you can mark them up as Total columns, but the option is not available in POwer BI? 

Is this possible, or is there a way using measures or any other way to achieve the same result ? 

Thanks

Neil 

[Anonymous · Accepted solution]

Hi @UK06B1 

You can consider to use custom visual and custom their bar color to implement it.

Download the Ultimate waterfall from store.

Then put the related field to the visual

Sample data 

Then set the bar color at format , e.g  we can set the total to 'grey' ,

Output

Best Regards!

Yolo Zhu

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

[Anonymous · Accepted solution]

Hi @UK06B1 

You can consider to use custom visual and custom their bar color to implement it.

Download the Ultimate waterfall from store.

Then put the related field to the visual

Sample data 

Then set the bar color at format , e.g  we can set the total to 'grey' ,

Output

Best Regards!

Yolo Zhu

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

[UK06B1 · Accepted solution]

Hi , thanks that works great. I also used the define pillars selection to switch on the total as in the screen shot here . Thanks again for your help.