Is there a way to show only the first value in a table?

[Schoolsupport]

Hey There Community,

I have a question,

I Have a Table with a lot of data in it but I only want to see the first value because otherwise it's too long.

I don't want to make the table bigger because i need the space for something else.

I also don't want it to make it smaller because i don't like the scrollbar.

Hope someone knows the answer.

[amitchandak]

@Schoolsupport , The information you have provided is not making the problem clear to me. Can you please explain with an example.
Not sure we taking about the visual table or Data Table
Appreciate your Kudos.

[Schoolsupport]

hey there @amitchandak,

Talking about a visual table.

Sorry forgot to add that part.

But as i was saying i only want to see the first value.

Example:

there are 500 items in a table

but the only one i want to see is the first one and nothing more.

[v-xuding-msft]

Hi @Schoolsupport ,

I don't know what your actual situation like. Maybe you could use Top N filter in filter pane. Or if you have date column, you could try the date relative slicer to filter data.

Top N filter 

Creating a relative date slicer and filter in Power BI 

The blog that Greg suggested is a good article. If it is helpful for you, please accept it as solution. If you have any questions, please share a few screenshots and other details with us. Thanks!!

[Greg_Deckler]

@Schoolsupport - @Pragati11 has a great article for this I think:

https://community.powerbi.com/t5/Community-Blog/Controlling-Number-of-Rows-to-Be-Displayed-in-a-Tabl...