two different visuals with the same chart-axis range

[Anonymous]

Has anyone been successful with having the same chart-axis range with two different visuals?

For example, I have two line charts where the y-axis range changes dynamically for two data sets. I would like the y-axis range to be established by the data that requires the larger range and then apply that range to both visuals.

[WillBr]

I have a solution but requires a little work. 

Using a measure you will need to find the Max value from each of the charts then the max value from the 2. Now set the max range to this measure. 

Max Rounded Value =

VAR MaxA =

    MAXX(

        SUMMARIZE(

            'Table A',

            'Date table'[Date].[Month],

            "Total A", SUM('Table A'[Value A])

        ),

        [Total A]

    )

VAR MaxB =

    MAXX(

        SUMMARIZE(

            'Table B',

            'Date table'[Date].[Month],

            "Total B", SUM('Table B'[Value B])

        ),

        [Total B]

    )

VAR MaxValue = MAX(MaxA , MaxB )

VAR RoundedResult =

    SWITCH(

        TRUE(),

        MaxValue <= 100, CEILING(MaxValue, 10),

        MaxValue<= 1000, CEILING(MaxValue, 100),

        MaxValue<= 10000, CEILING(MaxValue, 1000),

        CEILING(MaxValue, 10000)

    )

RETURN RoundedResult

[K_cherry]

To expand on this, just wanted to bring attention to the F(x) button for a range maximum, which is where you can associate your chart max with a measure.  By the way, in my measure, I multipled my result by 1.16 so that the max line actually showed up (it truncates it for some reason).

[Ady_Stone]

Hi I wonder if anyone has an idea on how this can be achieved as there has been no solution to this.

I am sure that many have run into the same issue and mine is exactly the same. I need two charts side by side and for them to dynamically scale the Y axis to the maximum value plotted  

[ChristaA]

Following up in case you haven't yet found your answer. In trying to do the same thing, I ended up using small multiples, then editing the visualization setttings to accomodate the numner of related charts I had. This seems to work as desired.

[v-diye-msft]

Hi @Anonymous 

Do you mean to achieve the below results?

[Anonymous]

I should have posted an image from the start.

I have two visuals with different ranges of y-axis. When finished, I still want two visuals but with the same ranges of y-axes.

[Anonymous]

It is easy to change the ranges manually to match. I need the ranges to change dynamically together as I select other sliders and filters.

[amitchandak]

You might have to find a custom one. There is an idea for this, Please vore for that

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7135315-multiple-y-axis-on-a-char...

[Anonymous]

I actually want 2 different charts with the same axes. Not a single chart with multiple axes.