Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Experts,
I have this data here whereas my table has these 3 columns:
1. Month
2. Year
3. Employee Name
I want my Card to show the distinctcount of employee name on the latest Month & Year by default, and show the selected Month and Year if there is any selection.
Kindly advise! Thank you!
hi @winniexlee
try like:
Hihi, the result is not showing correctly.
I forgotten to mention that i have a column name "Employment Type" in another table, whereas i only want to look at those that are labour supply or permanent employees. Is it possible to use Month Name instead of Month Number also?
hi @winniexlee
1. you can place a slicer or filter for labour supply or permanent types.
2. Month Name instead of Month Number? seems fine. Just give it a try.
p.s. please consider @someone, if you seek further suggestions.
@FreemanZ apologies, I already have a Slicer for Month, Year and Employment Type.
hi @winniexlee
try like:
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
10 | |
6 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |