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!

[PereiraDeCastro]

I've been fighting with the same issue and this lacking PowerBI feature. When drilling down with a fixed maximum the visuals become unreadable, and the calculated measures cannot apply the INSCOPE function, meaning that there is no way to tell which level is applied from the hierarchy on the x-axis. One solution is to drill through levels via buttons that apply bookmarks using fixed maximums. I also found another workaround - its not the most beautifull solution but it gets the job done:

You can add a second line to the Y-axis using the same values as your column y-axis. You can then hide it again using the formatting options. Even here, PowerBI provides limited options, and I ended up just inserting a shape over the legend item and renaming the values for the visual as " ".

Assuming that the line and the column have the same maximum values, and that you have your minimum range set to 0 with aligned zeros, then the primary and secondary axes should now be aligned.

[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.