Forum Discussion

JM_nxgn's avatar
JM_nxgn
Helper I
7 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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's avatar
JM_nxgn
Helper I
7 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    JM_nxgn
    Helper I
    7 years ago

    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's avatar
    JM_nxgn
    Helper I
    7 years ago

    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!