Forum Discussion

OneWithQuestion's avatar
OneWithQuestion
Post Prodigy
9 years ago

Line and column chart: do NOT connect line points?

Is there anyway to format a line chart or rather a combo line chart so that the lines themselves are not shown just the dots?     See how some are independent dots and others are connected. ...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
9 years ago

Hi OneWithQuestion,

 

In a line chart, we are not allowed to remove the lines to just show dots. If we need to see data dots in a chart, we should choose scatter chart, however, there is no such a scatter and column combination chart to achieve your requirement.

 

As Phil_Seamark said, the only workaround to remove lines is to putthe unconnected groups into their own series and add the series value to the Legend.

 

Thanks,
Yuliana Gu

hymieho's avatar
hymieho
Resolver I
9 years ago

Excel supports this so we are just asking for feature parity.

 

  • hymieho's avatar
    hymieho
    Resolver I
    9 years ago

    With the latest release of PBI Desktop this is ALMOST achievable...if only we could make the line color transaparant, or set the Stroke Width to 0.

     

    Using a white line on a white background works as long as the line does not cross any of the bars. Sooooo close... please take us the last mile, Microsoft.

     

    • OneWithQuestion's avatar
      OneWithQuestion
      Post Prodigy
      9 years ago

       white lines distract my users still... if there was just a "transparent" color option that would sort the issue!

    • kfollmer's avatar
      kfollmer
      Regular Visitor
      7 years ago

      How are you changing the line color seperate from the join marker color?

      • hymieho's avatar
        hymieho
        Resolver I
        7 years ago

        Line Color (under Data Colors) vs. Marker Color (under Shapes). However this feature has been fixed and this should be marked as "done" because you can now set the Line Stroke Width to 0. Thanks Microsoft. :)