Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have a bar chart with two measures (the main and the alternative one). I'd like to set a customized max range depending the selected measure.
I tried to use functions like GetObjectMeasure() without luck. You know something like that:
If(GetObjectMeasure()=1,0.1,500)
My intention is to use the standard features included in the Bar Chart.
Thanks in advance
Hi, GetObjectMeasure() is giving not a number, but name of measure (label) in text string format. So your approach with it should work, but try to modify formula to something like this:
If(GetObjectMeasure()='Measure1',0.1,500)
where Measure1 is your first measure name/label.
Hi, Sorry was my mistake when I wrote the entry in the forum. My tests were comparing the result of GetObjectMeasure() vs the measure's name. It didn't work.
It didn't work inside max range fx:
Regards