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 Everyone,
I need your help , I am trying to show Top 10 names in power bi Vis, Names are in six column and i want to show which top 10 names appeared most in these 6 columns.
Name 1 | Name 2 | Name 3 | Name 4 | Name 5 | Name 6 |
A | E | B | A | E | J |
B | C | A | D | A | A |
E | A | B | C | B | D |
C | A | B | V | A | |
D | D | L | K | V | A |
M | L | K | V | A |
These are Top names:
A=10
B= 5
D= 4
C= 3
E= 3
Appreciate your help. Thanks
Hey @A9kurs !
You can merge the six columns into a single column using the "Unpivot Columns" feature. This will create a new column with the column names as a separate column, allowing you to easily count the number of occurrences of each name.
Best regards,
Marcel
Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI
Hi Marcel,
Thanks for help,
I am trying to show Distinct names and there count of null. If i do unpivot it gives distinct name but count i need is for next column of name. As shown in below example.
Name 1 | Count Name 1 | Name 2 | Count Name 2 | Name 3 | Count Name 3 | |
Abc | 02/03/21 | Def | null | Fgh | null | |
Def | 02/03/21 | Fgh | null | Abc | null | |
Abc | null | Xyz | Null | Abc | null | |
def | null | Abc | 02/05/21 | Fgh | 02/05/21 | |
Ghi | Null | Def | 02/05/21 | GhI | Null |
I am trying to show names and there count of null
Abc 3
Def 2
GHI 2
XYZ 1
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
75 | |
71 | |
38 | |
29 | |
26 |
User | Count |
---|---|
97 | |
96 | |
60 | |
44 | |
41 |