Skip to main content

Power BI

Needs Votes

Waterfall Conditional Colors (Starting Point)

Vote (13) Share
Kevin's profile image

Kevin on 23 May 2019 21:22:29

With the current waterfall chart visual you can achieve almost any values you need by using SWITCH and a helper table. You can create a starting point, subtotals, and use individual measures using this method, but the limitation is that you cannot change the color of the starting point or subtotals.

So close! If conditional formatting was added to sentiment colors for the Waterfall Chart visual, we would have everything we need.

Example of how the SWITCH and helper table work: https://businessintelligist.com/2017/04/03/price-volume-mix-analysis-using-power-bi/