Forum Discussion
Limiting number of Rows in Table Visual
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!
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
6 Replies
Hi JM_nxgn ,
Can you upload sampledata, pbix and output expected to Google / OneDrive and share the link to find a solution.
Cheers
CheenuSing
Anonymous
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.
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
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
