Forum Discussion

Anonymous's avatar
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's avatar
    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's avatar
    mykbitz
    7 years ago

     Removing the Line

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

     

Anonymous's avatar
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's avatar
mykbitz
Icon for Advocate II rankAdvocate II
7 years ago

 Removing the Line

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

 

  • dcorentin's avatar
    dcorentin
    Icon for Advocate I rankAdvocate 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.

     

  • Krampis's avatar
    Krampis
    Frequent Visitor
    7 years ago

    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!

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Unbelievable.

    So much time spent searching for this, so many help threads, and such a simple solution.... Good job Microsoft :(

  • QuinnP's avatar
    QuinnP
    Icon for Advocate II rankAdvocate II
    7 years ago

    mykbitz Genius Mate

  • qiuyujx's avatar
    qiuyujx
    New Member
    6 years ago

    Finally, someone understood the problem. This should be the accepted answer. Thanks.