Forum Discussion
Line Chart appears non-continuous
Hi peternguyen2 ,
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.Please show the expected outcome based on the sample data you provided.
How to provide sample data in the Power BI Forum - Microsoft Fabric CommunityRegards,
Harshitha.
Hi peternguyen2
That behavior is expected because using a column in the legend splits the values into separate groups, preventing any overlap. Some possible workarounds, though not ideal:
- Conditionally formatting a column chart prior to converting it to a line chart
Please see this vlog - https://youtu.be/3WXwIC8j6Y8?si=r54rttQmD8NxLwBY
-Use mutiple measures: one for each legend value and another one that isn't filtered down to a legend value.
In both approaches, however, the legends are separate from the line chart visual itself. The first approach relies on conditional formatting, so no legends are displayed. The second approach uses four separate measures, resulting in an additional legend that must be hidden.
Please se the attached pbix.