cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Prodigy

## 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.

1 ACCEPTED SOLUTION
Super User

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.

Regards

Miguel Félix

Proud to be a Super User!

Check out my blog: Power BI em Português

Super User

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.

Regards

Miguel Félix

Proud to be a Super User!

Check out my blog: Power BI em Português

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.