Same end value / range for Y axis for two visuals

[Pikachu-Power]

Hello,

like the subject says... i have two visuals (two bar and line charts) with different end value for the y axis. The visuals should have the same end value for a better comparability. Are there some techniques to do that?

I was thinking about MAX of all line and bar values and take this for the y axis. But there is also a drillup funktion for month, quarter and year... in month it is MAX value, in quarter and year the LAST value... that makes it a little bit complicated. But maybe there are some other methods to implement that?

Many thanks.

[MFelix · Accepted solution]

Hi @Pikachu-Power ,

For this you need to create a measure similar to the one below:

Quarter/month MAX =
IF (
    HASONEVALUE ( 'Table'[Month] ),
    MAXX (
        SUMMARIZE (
            ALLSELECTED ( 'Table' ),
            'Table'[Year],
            'Table'[Month],
            "TOTAL VALUE", SUM ( 'Table'[Value] )
        ),
        [TOTAL VALUE]
    ),
    MAXX (
        SUMMARIZE (
            ALLSELECTED ( 'Table' ),
            'Table'[Year],
            'Table'[Quarter],
            "TOTAL VALUE", SUM ( 'Table'[TOTAL VALUE] )
        ),
        [TOTAL VALUE]
    )
)

This may need some changes based on your values and also a IF statement to remove the where you have blanks.

Then use this metric has your MAX value on your visualizations.