Forum Discussion
Post ProdigyVisual to show headcount by week ending.
I have data showing by trainer name - what is their average headcount for every week ending. Example I'd like to see John Doe trained week ending 12/25/21 and had 15 Team member and then on week ending 1/1/22 had 13 attendees. Perhaps something that looks like a Gantt Chart - Any ideas? maybe something like below?
| Trainer | Line of Business | Training Start Date | Week Ending | Headcount | |
| Doe, John | Pharmacy | 12/20/2021 | 12/25/2021 | 25 | same class |
| Doe, John | Pharmacy | 12/20/2021 | 1/1/2022 | 23 | |
| Smith, Katy | ecommerce | 12/6/2021 | 12/25/2021 | 25 | same class |
| Smith, Katy | ecommerce | 12/6/2021 | 12/11/2021 | 30 | |
| Schmoe, Joe | Pharmacy | 12/13/2021 | 12/18/2021 | 10 | same class |
| Schmoe, Joe | Pharmacy | 12/13/2021 | 12/25/2021 | 9 |
2 Replies
- amitchandak
Super User
jcastr02 , I have attempted one using matrix using visual.
But not able to fit with your output value.
See if this can help Matrix as Project plan Visual: https://youtu.be/R25QoiyoSVs
radhey_recResolver II
Hi jcastr02,
I am able to produce following visual (with the help of https://pbivizedit.com service):
Given this, I am not sure, it will be able to satisfy your requirements OR will reach near to want you want.
Will it be possible for you to give me the final data (in csv format) that will be rendered in the visual? Let me see If I can help you out.
FYI, the service generates custom visuals on demand and at the moment it does not support:
- native power bi tooltips
- selection
Thanks,
-R
