Forum Discussion
Creating a dynamic y-axis on a clustered column chart with a legend
Hi deedoubleewe
The immediate issue appears to be that the maximum value should be determined at the granularity of the Legend & the X-Axis field combined.
Assuming the field on the X-Axis is
Table[Category], something like this should work as expected:YAxis Max = CEILING ( MAXX ( SUMMARIZECOLUMNS ( Table[Legend], Table[Category], "@Value", [Value] ), [@Value] ) + .05, 0.2 )You can debug or verify that
YAxis Maxis returning the expected value by displaying it on a separate Card visual (subject to the same filters applying to the original visual).Does something like this work for you?
Super UserHi deedoubleewe
The immediate issue appears to be that the maximum value should be determined at the granularity of the Legend & the X-Axis field combined.
Assuming the field on the X-Axis is Table[Category], something like this should work as expected:
YAxis Max =
CEILING (
MAXX (
SUMMARIZECOLUMNS ( Table[Legend], Table[Category], "@Value", [Value] ),
[@Value]
) + .05,
0.2
)
You can debug or verify that YAxis Max is returning the expected value by displaying it on a separate Card visual (subject to the same filters applying to the original visual).
Does something like this work for you?
OwenAuger That worked perfectly! I figured I needed some combination of the variables, but couldn't quite get it right. This is exactly what I needed. Thanks 🙂