Limiting number of Rows in Table Visual

[JM_nxgn]

Hi all, 

I've created a table visual which holds a couple of million rows of data. I only want the users of the table to be able to see at most 100 rows at any point in time. This forces them to have to filter down to a granular level to find exactly what they're looking for.

Is there a way that I can limit the number of Rows on the table visual to be at most 100 regardless of if there are any filters applied?

Thanks in advance!

[iheheb9]

To solve this you need  a function like this 

RowNum = CALCULATE (COUNT( PrincipalData[Index] ), FILTER ( ALLSELECTED ( PrincipalData ), PrincipalData[Index] <= MAX ( PrincipalData[Index])))
which gives you the line number, respecting all the filters
After that you can follow the method of filters, where u filter that measure like RowNum < 5.
Hope this helps

[CheenuSing]

Hi @JM_nxgn ,

Can you upload sampledata, pbix and output expected to Google / OneDrive and share the link to find a solution.

Cheers

CheenuSing

[JM_nxgn]

@CheenuSing 

https://drive.google.com/file/d/1gP9uvqQPESrwRxSW-_FWSzQgzspNZWXX/view?usp=sharing

Consider that .pbix file, the table visual has 7 rows total. Say I wanted to limit the number of rows which were visible to at most 5 only. It doesn't matter which 5, but only 5. 

So currently we can see all 7 rows like this:

BeforeAfter

The 'After' picture does not neccessarily need to be the first 5 rows, it can be any of the 5.

[CheenuSing · Accepted solution]

Hi @JM_nxgn 

Just try the steps I have pasted in the Filter Pane and you may be able to see the results you wanted.

Cheers

CheenuSing

[JM_nxgn]

Hello,

Upon further testing I'm finding some issues. Since we showing TOP 5 by MAX of OwnerId, when I start applying additional filters on the table, I sometimes have no values within my table visualisation leading me to think that it's not showing because those values are not part of the TOP 5 MAX of OwnerId's.

[JM_nxgn]

Thanks, this solution works well. Is there a method to do this without selecting the MAX OwnerId's, but rather randomly chosen ones? I will accept that as a solution though, thanks for your help!