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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
User12345432334
Regular Visitor

How to display 20 rows of a visual table

I have a table with 3 columns: technologies, summary and count where i display the total number of each summary split by technologies. Right now it displays them in order, which is good:

User12345432334_0-1720691648291.png

 


Now I want to display only the first 20 rows. When I go to filters panel and i select top N for summary and the value is the count column, it displays 22 instead of 20 and the values are not in the correct order:

User12345432334_1-1720691713227.png

After value 245 I should have 231, instead I get 199 and the order is not right. What can be the issue?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @User12345432334 

 

@audreygerred Thank you very much for your prompt reply and here allow me to share some of it.

 

When applying the first N filters, make sure you select the correct field for the filter. It should be set to filter the Summary column based on the Count value.

 

vnuocmsft_0-1721636067498.png

 

If there are duplicate values in the Count column, the first N filters may contain more rows than expected.

 

Ensure that no other filters or slicers affect the visual object. Other filters may affect the data displayed.

 

If these steps do not solve the problem, you may want to consider create a measure, for example:

 

rank count = RANKX(ALL('Table'), CALCULATE(SUM('Table'[count])),, DESC, Dense)

 

vnuocmsft_1-1721636178339.png

 

Here is the result.

 

vnuocmsft_2-1721636416171.png

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi @User12345432334 

 

@audreygerred Thank you very much for your prompt reply and here allow me to share some of it.

 

When applying the first N filters, make sure you select the correct field for the filter. It should be set to filter the Summary column based on the Count value.

 

vnuocmsft_0-1721636067498.png

 

If there are duplicate values in the Count column, the first N filters may contain more rows than expected.

 

Ensure that no other filters or slicers affect the visual object. Other filters may affect the data displayed.

 

If these steps do not solve the problem, you may want to consider create a measure, for example:

 

rank count = RANKX(ALL('Table'), CALCULATE(SUM('Table'[count])),, DESC, Dense)

 

vnuocmsft_1-1721636178339.png

 

Here is the result.

 

vnuocmsft_2-1721636416171.png

 

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

audreygerred
Super User
Super User

Can you send screenshots of all filters for bothe scenarios (topN and not topN)?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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