End of Y-Axes based on Measure

[joshua1990]

Hi!

I have a bar chart that shows me the value for a measure per week.

I would like to limit the End of the Y-Axes based on the MAX value within the full range of all weeks.

For instance, if the value for the latest week is 5.000 and week 20 = 10.000, then the Y-Axes should end at 10.000.

How would you do that using a measure within the Y-Axes settings?

[V-lianl-msft]

Hi @joshua1990 ,

Try what the @Greg_Deckler  said. You could create a measure like below:

Measure = MAXX(VALUES(financials[Country]),CALCULATE(SUM(financials[Profit]),ALLEXCEPT(financials,financials[Country])))

In this formula, my x axis is financials[Country].

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@joshua1990 There should be a small fx button next to the Start and End values for Y-Axis in column charts and the X-Axis in bar charts. You could write a simple measure, MAX('Table'[Column]) to set the max or min value.