Forum Discussion
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 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.
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
4 Replies
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 | MIEAnother alternative would be SVG which can also give you the data labels back (if you code for it)
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.
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.
