Conditional Formatting on Waterfall graph (and syncing y-axis')

[Namoh]

Hi, 

We're trying to replicate a Graph that's now made in Excel.

We have 2 Waterfall graphs, 1 with Planned values and 1 with Actual values.

Via 2 slicers we can select the Month and Facility that we would like to see, this works perfectly!

We would like to adjust the colors based on the difference between Planned and Actuals.

This could be done via Condiotinal Formatting (have done something similar with Clustered Bart Charts) but can't find this option.

Anyone any idea how to do this with the standard Waterfall chart (or with another add-on Waterfall visual)?

Next small issue, that we need to solve, is to sync the y-axis off both graphs.

As you can see the left graph goes to 200 while the right graph goes to 300.

How to sync these 2 y-axis?

[amitchandak]

@Namoh , The only option I can think off is give min max value for y -axis

[Namoh]

Hi amitchandak, thanks for the reply. 

I've looked at that option as well, but because the values are dynamic this won't work.

Depending on the month and facility that has been chosen the max value could be 150 or 1500 (or more). 

When putting the max at 1500, then the bars with the max 150 value won't show nicely.

It's currently the best option but is doesn't suffice.

Any help on the Conditional Formatting issue?