Forum Discussion
Post PatronDynamic Y-Axis for SPC (Summary Table)
Hello,
I have an SPC (Summary) table - based on control on PBISPC_DEV Version: 1.4.4.20 - which I converted to a graph:
But I now want the Y-Axis to be a dynamic one, by modifying the upper limit for Y-Axis to utilise that same field currently being used for the Outcome/Numerator:
However, when I apply this, some of the points get cut off:
The highest value in the current graph (the first image above) is slightly under 900. I am confused why the dynamic method I am seeking does not take that in to consideration (and only includes data points up to around 600'ish).
Kindly advise.
Regards
Make sure the Y-axis upper limit uses the same aggregation as your chart measure and includes all data.
Use a formula like:
Max( Max([Outcome]), Max([UCL]) )
or (if your chart uses sums):
Max(Sum([Outcome]))
our dynamic Y-axis must calculate the true max value (or include UCL) — not an averaged or filtered version — to stop points from being cut off.
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos.
6 Replies
F_RehI created the measure, in the form recommended:
Upper Limit =
MAXX ( VALUES ( Table[Column on X-Axis ), [Measure used for line chart] )However, when I apply this measure as the upper limit in Y-Axis Settings it changes from a Y-axis maximum value of 1,300 to 1,600 and thus even more detrimintal:
- Ashish_Mathur
Super User
Hi,
As far as i know, the Y axis should dynamically adjust automatically. Share the download link of the PBI file and show the problem there clearly.
- Rufyda
Make sure the Y-axis upper limit uses the same aggregation as your chart measure and includes all data.
Use a formula like:
Max( Max([Outcome]), Max([UCL]) )
or (if your chart uses sums):
Max(Sum([Outcome]))
our dynamic Y-axis must calculate the true max value (or include UCL) — not an averaged or filtered version — to stop points from being cut off.
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos. 
v-echaithraCommunity Support
Hi F_Reh ,
If the issue still persists, we kindly request you to share the sample data in a workable format such as text, an Excel file, or a PBIX file with sample data instead of screenshots. Additionally, please include the expected output. This will enable us to assist you more effectively.
Best regards.
- v-echaithra
Hi F_Reh ,
Could you please confirm if the issue has been resolved or please share a sample data in a workable format such as text, an Excel file, or a PBIX file with sample data. If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.
Thank you.
