Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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.
@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.
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |