Forum Discussion
How to transform a dot into a line?
Hey everyone,
Is there any way to tranfer the green 'Target' dot into a constant dashed line? I am using Line and Clustered Column visual:
I am using a measure to calculate the target, it's basically LY * 1.2, as the target is to increase sessions by 20%. For this reason I can't use the constant line from Analytics.
Looking forward to hearing your helpful commnets!
6 Replies
- amitchandak
Super User
Anonymous , but this is the legend and only one dot will shown for one set of legend , you can have line if you have more values on axis
amitchandak what should I use as the X axis then? I am using This year, Last year, 2 Years ago and constant measure (LY*1.2)
- lkalawski
Resident Rockstar
Hi Anonymous
If you want a line for all values, you need to create an additional measure that will return the value as a constant (for example, based on a selection).
If you want a line instead of a dot (but only for one bar), you can do this:
In the Shape settings you need to enable "Show marker" and change Marker shape to line:
_______________
If I helped, please accept the solution and give kudos! 😀 
FarhanAhmedCommunity Champion
Go to Shapes property in Visual
You can change the Marker Shape to "Line" and increase the size upto 20. This may not be the actual line but this might help.
This doesn't really help, I was thinking about creating this out of the dot:
See the blue line above, the line is not constat, it's measured using the measure (LY * 1.2)
- FarhanAhmed
For Line you need 2 points to be connected, which in this is case is not happening.
Unfortunately your x-axis should have atleast 2 values in order it to make a proper dotted line.
What you can do is to achieve that is.
1- Put year in x-axis from Date table
2- Put Sum Amount in Values ( this will categorize your data into multiple years)
3- Use Target measure in Line Values
