Forum Discussion
Pikachu-Power
Impactful Individual
3 years agoSame 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 th...
- 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.
MFelix
Super User
3 years agoHi 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.