Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
OneWithQuestion
Post Prodigy
Post Prodigy

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?

 

ComboLineChartPowerBI.PNG

 

See how some are independent dots and others are connected.

 

It just looks REALLY odd since some of those do not have any datapoints shown in red.  It would be better to be able to choose a single dot with no join lines, and in a perfect world even pick a shape like triangle, circle, square, etc....

10 REPLIES 10
carolnmarr
Regular Visitor

Does anyone know if this has been resolved or if there is an Idea to track this? My client requests this every week, as we have a very similar scenario where the "dots" are reference points, and have no relevancy to other points to the right and left of them. It is very confusing that they connect.

v-yulgu-msft
Employee
Employee

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

 

column + line chart with line markers but no line.JPG

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.

 

dots.JPG

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

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

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

With putting unconnected groups in their own series, that would just cluster them together right?

In the case of my example those bars are showing people, and then the height of the bar is showing types of work assigned to them.

 

X of these task types, Y of another task type, Z of yet a third.

 

Then the line is showing how many tasks are overdue.

 

Basically, NO ONE wants a red dot/line indicating they have late work.  (Project contract not returned, or some customer response deadline missed etc...)

 

But, I don't see any other way to indicate that with Power BI.

 

Grouping the people together wouldn't make sense as there isn't any trend from Jason Smith to Joan Berkley, etc... just Jason had 2 overdue and Joan has 1, while Sally Robinson has zero (she's keeping up on her work kudos to her!) etc...

Phil_Seamark
Employee
Employee

One option if you want to remove joins is to look at putting the unconnected groups into their own series and add the series value to the Legend.  This might give you lots of colours depending on how many groups you have.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.