Split legend in 2 for Column Line Chart

Hii Emmy88_ 

Power BI doesn’t support splitting or grouping legends in a line & column chart. The legend is always a single flat list. The only workarounds are using two separate visuals or prefixing legend names (e.g., KPI – Target, Dept – Sales) to visually group them. The empty (Blank) legend item can be filtered out at visual level or replaced with a label like “Other” without affecting totals.

You can’t split the legend into two sections in a single Line & Stacked Column chart. Power BI only supports one legend field per visual, so lines and columns must share it.

What you can do instead:

• Fake a split legend:
  Use two visuals layered on top of each other.
  One visual shows only the lines (Target / Total EFD) with its own legend.
  The second visual shows only the columns (Departments) with a separate legend.
  Align them carefully so they look like one chart.

• Control legend order & grouping:
  If your legend comes from a column, create a sort column so KPIs (Target, Total EFD) appear first, then departments below. This won’t visually separate them, but improves readability.

• Remove the “(Leeg)” legend item:
  Replace blanks in the legend field with a label like "Other" or use a calculated column that returns BLANK() only for the legend field, while keeping the original column for calculations. Power BI hides blank legend values but still includes them in totals.

Unfortunately, there’s no native way today to have two independent legend sections inside one visual.

HI Emmy88_ Thanks for asking questions. 

Power BI doesn’t currently support splitting or grouping legends natively the legend is always shown as a single flat list.

What you can do instead:

1. Use two visuals

• Create two separate charts and layer them on top of each other

  • One visual for the lines (with its own legend)

  • One visual for the columns (with a separate legend)

• Carefully align them so they appear as a single combined chart

2. Prefix legend names

• Apply a naming convention such as “KPI – Target” and “Dept – Sales”

• This helps visually group legend items even though they remain in one list

3. Control legend order

• Create a sort column so KPIs appear first, followed by departments

• This won’t split the legend, but it does improve readability

To remove the “(Leeg)” / blank legend item:

• Filter out blank values at the visual level, or

• Replace blanks with a label like “Other”, or

• Use a calculated column that returns BLANK() only for the legend field while keeping the original column for calculations. Power BI hides blank legend values but still includes them in totals. 

Thanks

Hi Emmy88_ ,

If you get a chance to review cengizhanarslan, rohit1991 response, you’ll see that it aligns well with your requirements.

If you need any additional details, please let us know.

Thank you.

Hi Emmy88_ ,

May I know if your issue is resolved? If you need any additional details or assistance, please let us know.

Thank you