Horizontal reference line (not fixed)

[Borntoreport]

Hey community,

in a bubble chart i am showing the margins of our articels and want to set a reference line for the minimum margin for pointing out which articles are not profitable at the moment.

I know the analytics pane, but fixed values are not helpful. We have different product groups with each different minimum margins. At the end i want to be able to select a product group and see the margin of all articles which belong to the product group in reference to the minimum margin line.

Do you have any idea how to manage this? As an example the table below:

Group	Player	Salary	Reference Value
Real Madrid	A	200	400
Real Madrid	B	500	400
Real Madrid	C	300	400
Barcelona	D	200	200
Barcelona	E	500	200
Barcelona	F	200	200
Manchester United	G	100	300
Manchester United	H	600	300
Manchester United	I	100	300
Bayern München	J	200	500
Bayern München	K	300	500
Bayern München	L	400	500

Best regards!

[Greg_Deckler]

No good way since you can't put a measure in for a "Constant line". One thing that you could potentially do is to put a line graph behind your visual and tweak your opacity settings for your other visual to essentially have the line show through to your chart.