Forum Discussion
Akahn
Advocate IV
Advocate IVForce Single Y axis on combination charts
I have a bar/line combo chart. I want to force the visual to ONLY use a single Y axis. Can I force this behavior? Right now when I hide the second axis, it doesn’t change the chart. For example, ...
I have found a solution. However it is rather complicated!
I have used the custom formula for the maximum on each of the axies.
I created a measure which calculated the maximum value for bar and line values and then prints the higher value therefore alsways printing the highest number shown on the graph:
Then I call this in the formula section on both Primary and Secondary axies. As you can see below, this has worked for me...