Forum Discussion
Line and column chart: do NOT connect line points?
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
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...