Limit Number of Rows in View

[badm]

I have created a deck view of the data that I need. How can I only show the first 100 rows?

[Bellave_Jayaram]

Create a slice with condition such as [_RowNumber]<101

[albert_ch_wx]

Bellave_Jayaram:

reate a slice with condition such as [_RowNumber]<10

@Bellave_Jayaram
Sir, I just wanna require a solution for my question. I need to show the first 100 rows, and meanwhile meet the need of “score” column (data is digital) data <=30 and >=10. How can i achieve this? Please help me, thanks in advance.

[Kirk_Masden]

I’ve never done exactly what you are trying to do and I haven’t had a change to test this but I wonder if the following wouldn’t work as your slice condition:

IN([Name of your key column],TOP(FILTER(“Name of your table”,AND([score] <=30,[score] >=10)),100))

If I’m wrong I’ll be interested to see what the correct solution is.

[Kirk_Masden]

This is the same thing but it should be a litle easier to understand:

IN([Name of your key column],
    TOP(
        FILTER("Name of your table",AND([score] <=30,[score] >=10)
    ),100)
 )

It you know what FILTER(), TOP(), and IN() do, then you should be able to understand what this expression is supposed to do.