Is there a way to add logic to dynamically set the max value of a chart axis?
I have three different charts that all use the same measure but each of the charts use a different dimension for the categories. However, the user of the report is requesting that the max values of the primary axis all be consistent between the charts.
Thanks in advance
hi reaper,
as far as i know there is no way to use prompt macros for dynacmicaly adjust scale sizes. Seting a fixed max. value wont do the trick for you?
Setting a Max Value won't really work because the report developer doesn't want to set a fixed number and have the measure go over that value.
I think I might just be waiting for someone to tell me that it can't be done before I give them that answer. :)
Thanks though!
you are very welcome sir :)