Forum Discussion

Anonymous

Not applicable

8 years ago

Solved

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? ...

Need Help

Tips and Tricks

v-yuta-msft
8 years ago
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
mykbitz
7 years ago
Removing the Line
Go to Chart Format options >> Shapes, then set Stroke Width to 0 (Zero)

Anonymous

Not applicable

8 years ago

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!

v-yuta-msft

Community Support

8 years ago

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

Morten_DK
Helper I
8 years ago
I don't seem to have that option to show only markers. I am on March 2018 version - shouldn't it work there also?
Anonymous
Not applicable
7 years ago
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:

How can I do it?

Thanks!
- mykbitz
  Advocate II
  7 years ago
  Removing the Line
  Go to Chart Format options >> Shapes, then set Stroke Width to 0 (Zero)
  - dcorentin
    Advocate I
    6 years ago
    mykbitz Looks like show marker is no longer available in power BI? When I change the stroke to 0 I lose everything.
    
    Sorry about that I found the answer now, need to make x-axis categorical first.