Y axis start and end value keep consistent among different visuals on the same report page

[WendyDUFE]

Hi 

I want to display two visuals on the same report page to compare the two given customers' Measure value.

They can be

1)the same customer but different year

2)the different customer different year

3) the different customer but same year

To make it, I put two same visuals like below. However, the Y axis value is auto adjusted according to the give customer' measure figure, which is not that easy for the user to get which customer's ratio is higher initially looking at the visuals. It may confuse the user that in the snap below, their measure data is almost the same, but actually they are not. The left visual highest value is 800% but the right one over 2000%.

Is there a way to manipulate the two visuals to use the same Y axis start / end value ?

[v-zhenbw-msft · Accepted solution]

Hi @WendyDUFE ,

Sorry for that the Y axis start and end is auto, if you want to change the range, you need to configure it manually.

Perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner: https://ideas.powerbi.com/forums/265200-power-bi-ideas

Or you can create a measure. Put the measure in values and configure the color as white.

Please refer the following steps.

1. Create a measure and put it in Values in each of line chart.

Measure = CALCULATE(MAX('Table'[value]),ALL('Table'))*1.5

2. Configure the color of measure as white. Close the secondary Y axis.

Hope it can help you.

Best regards,

Community Support Team _ zhenbw

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

BTW, pbix as attached.

[WendyDUFE]

thanks, I think the measure works!

[veenashenolikar]

@WendyDUFE 

Have you tried using the options to specify a statis Y start value in Y-axis option of the Formatting tab?

[WendyDUFE]

@veenashenolikar, start value is fine, it can be set as 0 (statis value as you mentioned)., the problem is the end value because I don't know what is the proper end value to be set. The value can be very high ,e.g. over 3000%, if I set as 5000%, then when user select two customer whose measure value is within 100%, then the graph does not make any sense.

So I am wondering if there is any workaround to keep the two visuals' y axis end value consistent according to the measure value (the given customers selected by user from the slicer)