Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
User | Count |
---|---|
134 | |
68 | |
68 | |
54 | |
52 |
User | Count |
---|---|
207 | |
95 | |
64 | |
61 | |
57 |