cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SoniaL Member
Member

Line graph with dots/markers and no line

Hi, 

 

I'm hoping to recreate a graph similar to the below in power bi? It was created in excel by adding 'markers' to the line graph and removing the actual line. 

 

anyone able to help?

 

Capture70.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Line graph with dots/markers and no line

Hi SoniaL,

 

To change marker and line style, please drag a column to “legend” and switch to format->legend->style like below:

3.png4.png

 

Best Regards,

Jimmy Tao

10 REPLIES 10
rocky09 Established Member
Established Member

Re: Line graph with dots/markers and no line

@SoniaL

 

I Believe, you are using Line and Stacked Column Chart.

 

1. Go to Chart Format options, Go to Data color then Select the Color to white (Hiding the line)

2. Now, just below , there is a section called Shapes, Just Select Show Marker. That's it.

 

SoniaL Member
Member

Re: Line graph with dots/markers and no line

Hi @rocky09,

 

I can't see a 'show marker' option under shapes...

 

 

 Capture14.PNG

 

Also, in some cases, the line goes over the columns, so you can see the white ... there's no way to turn the line off completely?

 

Thanks again, 

 

Sonia

SoniaL Member
Member

Re: Line graph with dots/markers and no line

Ignore that, i released my x axis had to be on 'categorical'!

 

Ideally i can change the line to transperant, but I'm not sure there's an option for that... 

 

Thanks for your help!

Community Support Team
Community Support Team

Re: Line graph with dots/markers and no line

Hi SoniaL,

 

To change marker and line style, please drag a column to “legend” and switch to format->legend->style like below:

3.png4.png

 

Best Regards,

Jimmy Tao

Morten_DK Frequent Visitor
Frequent Visitor

Re: Line graph with dots/markers and no line

I don't seem to have that option to show only markers. I am on March 2018 version - shouldn't it work there also?

Krampis Frequent Visitor
Frequent Visitor

Re: Line graph with dots/markers and no line

I am actually having the same issue to solve. Changing line color to white does not help as it actually is white and if that overlaps with columns, then you can see white lines.

andera Occasional Visitor
Occasional Visitor

Re: Line graph with dots/markers and no line

Hi @v-yuta-msft,

 

This does not solve my problem. I am not trying to modify the look of the legend but I want to show a value using columns and another using markers only.

Like this:

columns and markers.PNG

How can I do it?

Thanks!

Highlighted
mykbitz Occasional Visitor
Occasional Visitor

Re: Line graph with dots/markers and no line

Stroke Width 2.PNG Remove Trend Line.PNGRemoving the LineStroke Width Zero.PNG

Go to Chart Format options >> Shapes, then set Stroke Width to 0 (Zero)

 

Krampis Frequent Visitor
Frequent Visitor

Re: Line graph with dots/markers and no line

This should be a very new functionality as I am sure I have tried to put it to 0 and did not work earlier. Now it works fine! Thank you!