Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I am trying to get a headcount of employees in a matrix. Each employee is assigned a "class" based on full time hourly, full time salary, PRN, or how part time. How do I get the columns to show the count of a combination of classes so all full time are counted together and all prn and all part time? See below - the big one is what I am pulling (by class) and the small inset one is what I am trying to accomplish.
Solved! Go to Solution.
I created a new column and grouped the classes by using =LEFT(Fieldname, # of characters) and it worked.
To make things easier, if you are pulling data, pull them in a flat table in excel then add additional column to group them class 1, class 2 etc in excel using a separate lookup table.
Then use power BI to read it
Not following the pulling them into a flat table in excel? We pull directly from an sql database. I have added new columns to combine first and last name, etc. Just can't figure out the counts.
Flat table as in
RN | Class 1A 8833 | Class 1 | 2 |
RN | Class 3 8833 | Class 3 | 1 |
Easier to count that way in power BI or pivot tables in excel
just my opinion
I created a new column and grouped the classes by using =LEFT(Fieldname, # of characters) and it worked.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
68 | |
53 | |
39 | |
33 |
User | Count |
---|---|
70 | |
63 | |
57 | |
49 | |
46 |