Forum Discussion
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?
Hi SoniaL,
To change marker and line style, please drag a column to “legend” and switch to format->legend->style like below:
Best Regards,
Jimmy Tao
Removing the Line
Go to Chart Format options >> Shapes, then set Stroke Width to 0 (Zero)
15 Replies
- rocky09
Solution Sage
Anonymous
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.
Hi rocky09,
I can't see a 'show marker' option under shapes...
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
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.
Another thing to check if you have no line and all of the answers above are not working:
If one of your values is NaN (not a number), then the line will not generate. I forgot to filter out one column with no data in it, and I got no line at all. Once I remember to filter out that bogus column, the line could then appear.
is it somehting like this`?
Looking for a powerbi visualization that can perform the above
br David
