Forum Discussion
Horizontal reference line (not fixed)
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!
1 Reply
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.
