Forum Discussion

GilbertGotfried's avatar
GilbertGotfried
Frequent Visitor
7 months ago
Solved

Two Column Line Graph with labeled markers

I'm trying to figure out a way to do this. It seems like it would be simple, and yet, unless I'm missing something, it isn't.                           For each employee, they hav...
  • Rufyda's avatar
    7 months ago

    Hi GilbertGotfried ,

    This can’t be done with native Power BI visuals.

    What you’re asking for is a hierarchical line chart
    (Employee → Task → Monthly count) with:

    Dynamic number of employees

    Dynamic number of tasks per employee

    Numeric Y-axis

    Data labels on markers

    Power BI doesn’t support this combination.

    Why each option fails:

    Matrix + Sparklines → no data labels

    Small multiples → not truly dynamic, breaks at scale

    Standard line chart → no Employee → Task grouping

    Recommended solution:
    Use a custom visual, preferably Deneb (Vega-Lite).
    It supports:

    Dynamic faceting by Employee

    Multiple task lines

    Full control over labels and layout

    Alternative workaround:
    Filter to one employee at a time using a slicer.

     

    Try these solutions and let me know if you need further clarification

    Regards,
    Rufyda Rahma | MIE