Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The 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.

Reply
A9kurs
Frequent Visitor

Trying to show count of top 10 names from multiple columns

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 1Name 2Name 3Name 4Name 5Name 6
AEBAEJ
BCADAA
EABCBD
C ABVA
DDLKVA
M LKVA

These are Top names: 

A=10

B= 5

D= 4

C= 3

E= 3

 Appreciate your help. Thanks

 

Capture.PNG

2 REPLIES 2
marcelsmaglhaes
Super User
Super User

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.

 

marcelsmaglhaes_0-1676485721096.png

 

marcelsmaglhaes_1-1676485744624.png

 

Best regards, 
Marcel


Regards,
Marcel Magalhães
Microsoft Power BI Official Partner
MCT | Certified PL-300 Power BI

If I've helped, don't forget to mark my post as a solution!



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 1Count Name 1Name 2Count Name 2Name 3Count Name 3 
Abc02/03/21DefnullFghnull 
Def02/03/21FghnullAbcnull 
AbcnullXyzNullAbcnull 
defnullAbc02/05/21Fgh02/05/21 
GhiNullDef02/05/21GhINull 

 

I am trying to show names and there count of null

Abc    3

Def     2

GHI    2

XYZ    1

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.