Dynamic Y-axis constant line when using multiples in graph

[ErikBi2]

Hey!

I have a graph where i use multiples. Is it possible to create a y axis constant line that's different for every version?

For example, on graph top left i'd want a line to be 1,6 whereas on graph top right it should be 0,0, etc, etc.

I've tried creating a seperate column where i define the value per graph name but when using this i've noticed it can only do summarization and gives the same value for all graphs.

See my pruple line drawn manually as an example

[ErikBi2 · Accepted solution]

For those in the future seeing this, i've solved this by not using the contstant lines, but just plottig regular lines from a helper table that I joined to the main table.

[v-echaithra]

Hi @ErikBi2 ,

Thank you @donsvensen  for your inputs.
We would like to confirm if you've successfully resolved this issue or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.

[donsvensen]

Hi

You can use Visual calculations to calculate the value - and use the value in the fx statement for your y-axis referenceline.

Be aware that the value that is used in the reference line needs to be the one at the total line in your visual - so you might need to use COLLAPSE to get the right value

Erik