For HR & People Teams
Power BI custom visuals for hr
Headcount movement, attrition by tenure and the hiring funnel: people views that answer the questions leadership asks every month.
For HR business partners, people analysts, CHROs. AI-generated, .pbiviz output, source code yours.
By Nawaf Sharaf · Founder & Reliability Engineer · Updated
This is the team view: everything hr teams build in Power BI, from visuals to page templates. For a single dashboard job in depth (its visuals, DAX measures and prompts), jump to the 1 hr dashboard jobs below.
People analytics in Power BI usually starts with a monthly HRIS extract: employees with hire and leave dates, positions, grades and org units. The monthly pack answers a familiar set of questions: how headcount moved (hires, leavers, transfers), where attrition is concentrated by tenure and team, how long hiring takes from requisition to start, and whether pay sits inside the bands. Native Power BI covers headcount trends and simple splits. The harder views are the ones that combine movement and distribution: a headcount bridge from opening to closing, an attrition heatmap by tenure band and department, a hiring funnel with time between stages, a box plot of salary against band minimum and maximum.
VizForge generates those as custom visuals from a description, packaged as a .pbiviz you import into Power BI Desktop. People data is sensitive, so the usual rules hold: the visual receives only rows the viewer is allowed to see under the model's row-level security, and it shows only what your measures aggregate. Describe minimum group sizes in the prompt and the visual can suppress small cells. Splits by legal entity, location or grade come from the model's own dimensions, so the same visual serves the group view and each business unit. For the page itself, the Design Studio has an HR headcount and attrition template with a sample model.
What hr teams need
- Headcount movement needs opening, hires, leavers, transfers and closing in one bridge, in that order
- Attrition is only meaningful by cohort (tenure band, team); an overall rate hides where people leave
- Small groups identify individuals; people reports must suppress cells below a minimum size
- Hiring funnels need time between stages, not just counts per stage
- Native Power BI has no box plot for pay-band analysis (as of November 2026)
Featured visuals for hr dashboards
Each card links to a full reference page with example prompts, data shape, and DAX measures. Generate any of these in under 5 minutes by describing what you want — no code, no developer time.
Headcount bridge from opening to closing.
Example: “Headcount waterfall for the selected month: opening headcount, hires, internal transfers in, transfers out, leavers, closing headcount.”
Attrition by tenure band and department.
Example: “Heatmap of 12-month rolling attrition %, departments as rows, tenure bands as columns, cells with fewer than 10 employees suppressed and sho…”
Salary spread against pay bands.
Example: “Box plot of base salary by grade, with band minimum and maximum as horizontal markers per grade, outliers as dots without names.”
Hiring funnel with stage timing.
Example: “Recruiting funnel: applications, screened, interviewed, offered, accepted, started, with median days between stages under each connector.”
Internal mobility between departments.
Example: “Sankey of internal moves in the last 12 months from department to department, link width by number of moves, links under 3 hidden.”
Headcount and attrition headline cards.
Example: “KPI card for current headcount with change vs last month, 12-month attrition % and a 12-month sparkline.”
Try one of these prompts
Click any prompt below to start a new visual. The prompt opens in your VizForge workspace pre-filled — edit it before generating, or generate as-is.
Example VizForge prompt
Attrition heatmap by department and tenure band (0-1, 1-2, 2-5, 5+ years) coloured by rolling 12-month attrition %, suppress any cell with fewer than 10 employees.
Example VizForge prompt
Headcount bridge from opening to closing headcount with hires, transfers in, transfers out and leavers, for the month picked in a slicer.
Example VizForge prompt
Salary box plot by grade with the pay band min and max drawn per grade, no names in tooltips, only counts and quartiles.
FAQ
Will row-level security protect employee data in the visual?
Yes. A custom visual receives only the rows that pass the viewer's RLS roles and filters, the same as a built-in visual. Keep personal fields out of tooltips unless the audience is cleared to see them.
Can the visual hide small groups?
Yes. Describe the threshold in the prompt (for example suppress cells under 10 people) and the generated visual shows a placeholder instead of the value.
Does it need a snapshot table?
Headcount trends are easiest with a monthly snapshot or a measure that counts active employees per date. The visual draws what the measure returns.
Is there a free HR dashboard template?
Yes. The HR headcount and attrition template in the Design Studio downloads as a background, theme JSON and a PBIP project with sample data.
Ready to ship your hr dashboard this week?
5 free credits on signup. No card required. .pbiviz output is yours forever.
Generate your first hr visual →Building for another team? See all teams.
HR dashboard jobs
Each page goes deep on one dashboard: the recommended custom visuals, the DAX measures behind them and ready-to-paste prompts.
Free hr dashboard templates
Free Design Studio page layouts for these dashboards: background image, theme JSON and PBIP project, no signup.
HR & people template
HR Headcount & AttritionLeft nav rail, 4 KPIs, two trend panels, three-panel workforce row
HR & people template
Recruitment & Hiring FunnelPlain header with logo, 5 KPIs, tall funnel left, source bars + department columns + open-requisition table right
HR & people template
Employee Engagement SurveyGlass header card, 4 KPIs beside eNPS score columns, theme comparison + department heatmap + question ranking
HR & people template
Learning & Training ComplianceLeft nav rail, compliance gauge + 4 KPIs, department bars + monthly completions, delivery donut + overdue table
HR & people template
Payroll, Overtime & AbsenceHeader card, 5 bold KPIs, payroll combo + pay-element donut, overtime bars + absence columns + department table
Design the page around it, free
A custom visual looks best on a designed page. The free VizForge Design Studio lays out a branded report page at Power BI’s pixel size and exports the background image, a theme JSON and a PBIP project. No signup.
Open the free Design Studio →Synoptic panels for hr
Floor plans and site maps with regions coloured by a measure.