Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
61 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |