Two Column Line Graph with labeled markers

[GilbertGotfried]

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 have a number of different event types or jobs. The line tracks the number by month. The number of employees is variable, depending on the team selected. The number of events is also variable, depending on what the employee does.  I want it to display like this: Employee and then their tasks grouped by each employee.  Then a labeled line showing the number of each of those tasks per month.

I can do a matrix with a sparkline, but my version of PB doesn't allow you to label the sparklines, which is necessary.

A regular line graph with small multiples doesn't work because the number of employees/events is variable so you never know how many multiples you're going to get. The number of rows depends on exactly what is selected. The max is 36 and there can be more than that.

The X axis is date, the Y is the number of events, the Y axis needs to be numeric, and small mutiples doesn't work.

[v-tejrama]

Hi @GilbertGotfried ,

Thank you @Rufyda  for the response provided!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you.

[v-tejrama]

Hi @GilbertGotfried ,

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

Thank you.

[Rufyda · Accepted solution]

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

[lbendlin]

Another alternative would be SVG which can also give you the data labels back (if you code for it)