Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
82 | |
62 | |
61 | |
58 |
User | Count |
---|---|
159 | |
114 | |
100 | |
75 | |
65 |