Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Icon for Impactful Individual rankImpactful Individual
3 years ago
Solved

Same end value / range for Y axis for two visuals

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.

Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    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.

1 Reply

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    3 years ago

    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.