Forum Discussion
Post PatronNew (card) Visual ideas - Headcount
Hi, Does anyone have any ideas for Headcount for HR Report?
I have used an icon from power point that shows 3 people and below are the measures relating to Headcount. But I am unsure what should go where with this visual? Does anyone have any ideas on what should show on the Card or any links that has some ideas, it is confusing at the moment.
Headcount =
CALCULATE(
DISTINCTCOUNT('Employee History'[Personnel Number]),
'Employee History'[IsActiveNoStarterOrLeaver] = TRUE()
) + 0
Headcount Arrow =
SWITCH(
[Headcount Indicator],
"Up", "🡵",
"Down", "🡾",
"No Change", "—"
)
Headcount Change =
[Headcount] -
CALCULATE(
[Headcount],
PREVIOUSMONTH('Dates'[Date])
)
Headcount Change % =
DIVIDE(
[Headcount] - [Headcount PM],
[Headcount PM]
)
Headcount Indicator =
SWITCH(
TRUE(),
[Headcount Change] > 0, "Up",
[Headcount Change] < 0, "Down",
[Headcount Change] = 0, "No Change"
)
Headcount PM =
CALCULATE(
DISTINCTCOUNT('Employee History'[Personnel Number]),
'Employee History'[IsActiveNoStarterOrLeaver] = TRUE(),
PARALLELPERIOD('Dates'[Date], -1, MONTH)
) + 0
Hi AvPowerBI
It seems you're looking for some visual ideas for representing Headcount in an HR report using Power BI.You can display the total headcount as a simple number in the card visual. This is the key metric everyone needs to see.
Display the Headcount Change % to provide context on how the headcount has changed compared to the previous month. This adds another layer of insight.
Instead of just numbers, consider using icons to represent groups or categories like teams or departments. This can help in making the visual more engaging.Apply color coding for quick visual representation (e.g., green for up, red for down.)
In your scenario :- Headcount 723 should be the biggest, boldest element — center it vertically and horizontally.
- Show % change with an arrow, paired together and color-coded (green for up, red for down).
- Reduce clutter by using smaller, lighter text for supporting info and removing “vs PM” wording.
- Optionally show the previous month’s value in brackets (e.g., ▼ 1.09% (Prev: 731)).
Hope this helps!!
Addtionally you refer doc : Create a (new) card visual in Power BI - Power BI | Microsoft Learn
6 Replies
- FBergamaschi
Super User
Hi AvPowerBI
What are you asking exactly?
Suggestions on visuals to use? Measures to implement? Or?
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
AvPowerBII have the below example, but I'm not feeling it and I don't know visually what people suggest on here can be possibly be done in this card (new) visual, it is very fiddley to use and getting fed up with it
v-aatheequeCommunity Support
Hi AvPowerBI
It seems you're looking for some visual ideas for representing Headcount in an HR report using Power BI.You can display the total headcount as a simple number in the card visual. This is the key metric everyone needs to see.
Display the Headcount Change % to provide context on how the headcount has changed compared to the previous month. This adds another layer of insight.
Instead of just numbers, consider using icons to represent groups or categories like teams or departments. This can help in making the visual more engaging.Apply color coding for quick visual representation (e.g., green for up, red for down.)
In your scenario :- Headcount 723 should be the biggest, boldest element — center it vertically and horizontally.
- Show % change with an arrow, paired together and color-coded (green for up, red for down).
- Reduce clutter by using smaller, lighter text for supporting info and removing “vs PM” wording.
- Optionally show the previous month’s value in brackets (e.g., ▼ 1.09% (Prev: 731)).
Hope this helps!!
Addtionally you refer doc : Create a (new) card visual in Power BI - Power BI | Microsoft Learn
