Synchronise primary and secondary Y axes

[dapperscavenger]

Hello

I have a combo chart, which uses drill throughs, as below:

Pic 1:

Pic 2:

As you can see, both axes are percentages.  The secondary axis can only ever be a max of 100%, as it represents the amount of time in the month that has elapsed.  The primary axis represents how much volume of our forecast we are expecting to consume; this axis can be both higher or lower, as you can see.

I want the two axes to be the same scale.  I could force it with setting min & max, but if I set it too high it is unreadable when the bars are low.  If I set it too low, I lose data.

I tried using a measure to create a max but, because I'm working with % fields, it's not quite working out. As you can see the scale cuts the bar too short (axis not high enough):

My last attempt:

Consumption MAX axis = if( [Cons Billed Lag3]+[Cons OO Lag3] >1 , [Cons Billed Lag3]+[Cons OO Lag3], 1) +0.1

where:

Cons OO Lag3 = if(sum('Fact APO'[Open Orders EU]) = 0, 0 , DIVIDE(sum('Fact APO'[Open Orders EU]) , sum('Fact APO'[WD20 Lag3 EU])))

Cons Billed Lag3 = if(sum('Fact APO'[Billed Sales EU]) = 0, 0 , DIVIDE(sum('Fact APO'[Billed Sales EU]) , sum('Fact APO'[WD20 Lag3 EU])))

Thanks for the help!

[amitchandak]

@dapperscavenger , You have option both can start with 0.

In the latest version you can control min and max Fx(means measure) so create a measure that can control that

Measure can changed based on need

[dapperscavenger]

oooh, never mind, it was actually better to just turn off all the axis options and revert to default !

[v-xulin-mstf]

Hi @dapperscavenger,

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thank you very much for your kind cooperation!

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[dapperscavenger]

Yes, that was the measure I posted, but it does not work.