Forum Discussion
Solved
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 hav...
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
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