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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

How do i make top10 visual table with ~13 rows

Zygis123_0-1699362286924.png

How would i aproach something like this?
first row is total tourist, second row is my country, third row is total tourist from other countries and then rank all other countries except mine.

1 ACCEPTED SOLUTION
chonchar
Helper V
Helper V

@Anonymous 

If you are using a table to visualize it, try this:

Double click the table with the data you want for "Top 10"

That should bring up the below pane. 

chonchar_0-1699368861216.png

 

As you can see, I have three data points in my table: Screens per user, User ID, and User Name. 

chonchar_1-1699368916113.png

 

Select Top N, put ten in "Top" and then drag the data point you want to ranked in the "By value."

 

Hopes this helps. Happy to reply again. 

 

-Cam 

 

View solution in original post

2 REPLIES 2
chonchar
Helper V
Helper V

@Anonymous 

If you are using a table to visualize it, try this:

Double click the table with the data you want for "Top 10"

That should bring up the below pane. 

chonchar_0-1699368861216.png

 

As you can see, I have three data points in my table: Screens per user, User ID, and User Name. 

chonchar_1-1699368916113.png

 

Select Top N, put ten in "Top" and then drag the data point you want to ranked in the "By value."

 

Hopes this helps. Happy to reply again. 

 

-Cam 

 

Ahmedx
Super User
Super User

Share sample pbix file to help you.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors