Forum Discussion
Dynamic Reference Line on a specific measure
Hi All,
Does anyone know how I can create a dynamic reference line using specific measures?
This is what I am After. The number changes occasionally, hence need to be dynamic.
I have tried to go to analytics pane, but none of the options allows me to use a measure that feeds those two number (casual min and FT/PT min measures).
Does anyone know any workaround that I want to achieve?
Thanks.
Cheers,
Kev
HI BigKev,
AFAIK, analyze lines can be config with the measure expressions that you used on visual fields. It does not support specify an external expression.
For this scenario, you can consider using the 'line and clustered column' chart with the measure expression on the line field.
Regards,
Xiaoxin Sheng
2 Replies
BigKev , You can create a clustered line visual.
There you can lines like
calculate([measure], allselected(Table))
HI BigKev,
AFAIK, analyze lines can be config with the measure expressions that you used on visual fields. It does not support specify an external expression.
For this scenario, you can consider using the 'line and clustered column' chart with the measure expression on the line field.
Regards,
Xiaoxin Sheng
