limit the number of rows visible in a visual table

[maurcollins]

Good Morning

I am trying to limit the number of rows that are visible in a table visual to 15. Is this possible. 

The visual has the following columns, Event, start time, room, event leader.

This data will be going onto a screen so i want to restrict the number of rows to 15 to make it more visible.

In total there are around 100 rows. I want to be able to show the first 15 on table 1, the next 15 on table 2 and so on.

Thank you

Maureen

[d_rohlfs · Accepted solution]

What you can do is use the Integer Divide function in the Power Query. 

Go to Power Query and this table, make sure that your rows are sorted how you would like them, and add an index (from 0). Then, with the index column selected, go to the add column ribbon, the From Number Group, then select the Standard button. This will give you a dropdown. Select the Divide (Integer) option. 

You should get a pop-out. Enter 15.

When you get the new column, you should see that the first 15 rows are 0, the next 15 are 1, and so on. 

On your visual, add a filter to each visual that filters on the Divide (Integer) column that was created. 

[maurcollins]

Hi

That worked thank you, there were some duplicate rows that i needed to delete first but does exactly what i want it to. 

[maurcollins]

Hi

The idea is to only show 15 items per table, so that when it is on a tv screen it is easy to see and understand, it will only show for each time period +/- 20 minutes at any time. So for example at 09:00 you will see all rooms for 09:00 and 09:15. 

Time	Date	Room
08:30:00	04/09/2023	018A
08:30:00	04/09/2023	124
08:30:00	04/09/2023	129
09:00:00	04/09/2023	50
09:00:00	04/09/2023	71
09:00:00	04/09/2023	50
09:00:00	04/09/2023	51
09:00:00	04/09/2023	7
09:00:00	04/09/2023	71
09:00:00	04/09/2023	81
09:00:00	04/09/2023	87
09:00:00	04/09/2023	0
09:00:00	04/09/2023	1
09:00:00	04/09/2023	G06
09:00:00	04/09/2023	G07
09:00:00	04/09/2023	21
09:00:00	04/09/2023	55
09:00:00	04/09/2023	56b
09:00:00	04/09/2023	62
09:00:00	04/09/2023	63
09:00:00	04/09/2023	68
09:00:00	04/09/2023	69
09:00:00	04/09/2023	70
09:00:00	04/09/2023	4
09:00:00	04/09/2023	7
09:00:00	04/09/2023	7
09:00:00	04/09/2023	9
09:00:00	04/09/2023	3
09:00:00	04/09/2023	009A
09:00:00	04/09/2023	126
09:00:00	04/09/2023	128
09:00:00	04/09/2023	108
09:00:00	04/09/2023	111
09:15:00	04/09/2023	13
09:15:00	04/09/2023	1
09:15:00	04/09/2023	16
09:15:00	04/09/2023	S1
09:15:00	04/09/2023	56a
09:15:00	04/09/2023	06A
09:15:00	04/09/2023	3
09:15:00	04/09/2023	102
09:30:00	04/09/2023	5
09:30:00	04/09/2023	2
09:30:00	04/09/2023	4
09:30:00	04/09/2023	1
09:30:00	04/09/2023	27
10:00:00	04/09/2023	66
10:30:00	04/09/2023	7
10:30:00	04/09/2023	9
10:30:00	04/09/2023	3
10:30:00	04/09/2023	124
10:30:00	04/09/2023	129
10:45:00	04/09/2023	13
10:45:00	04/09/2023	71
10:45:00	04/09/2023	81
10:45:00	04/09/2023	56c
10:45:00	04/09/2023	63
10:45:00	04/09/2023	102
11:00:00	04/09/2023	13
11:00:00	04/09/2023	71
11:00:00	04/09/2023	50
11:00:00	04/09/2023	87
11:00:00	04/09/2023	0
11:00:00	04/09/2023	16
11:00:00	04/09/2023	1
11:00:00	04/09/2023	55
11:00:00	04/09/2023	56b
11:00:00	04/09/2023	62
11:00:00	04/09/2023	68
11:00:00	04/09/2023	69
11:00:00	04/09/2023	70
11:00:00	04/09/2023	2
11:00:00	04/09/2023	4
11:00:00	04/09/2023	7
11:00:00	04/09/2023	1
11:00:00	04/09/2023	009A
11:00:00	04/09/2023	018A
11:00:00	04/09/2023	125
11:00:00	04/09/2023	128
11:00:00	04/09/2023	3
11:00:00	04/09/2023	27
11:00:00	04/09/2023	111
11:15:00	04/09/2023	50
11:15:00	04/09/2023	51
11:15:00	04/09/2023	4
11:15:00	04/09/2023	5
11:15:00	04/09/2023	S1
11:15:00	04/09/2023	108
11:15:00	04/09/2023	113
11:30:00	04/09/2023	13
11:30:00	04/09/2023	56a
12:45:00	04/09/2023	1
13:00:00	04/09/2023	4
13:00:00	04/09/2023	13
13:00:00	04/09/2023	12
13:00:00	04/09/2023	13
13:00:00	04/09/2023	59
13:00:00	04/09/2023	64
13:00:00	04/09/2023	66
13:00:00	04/09/2023	68
13:00:00	04/09/2023	69
13:00:00	04/09/2023	70
13:00:00	04/09/2023	4
13:00:00	04/09/2023	009A
13:00:00	04/09/2023	112
13:00:00	04/09/2023	111
13:15:00	04/09/2023	81
13:15:00	04/09/2023	87
13:15:00	04/09/2023	3
13:15:00	04/09/2023	2
13:15:00	04/09/2023	16
13:15:00	04/09/2023	66
13:15:00	04/09/2023	7
13:15:00	04/09/2023	9
13:15:00	04/09/2023	3
13:15:00	04/09/2023	102
13:15:00	04/09/2023	108
13:30:00	04/09/2023	50
13:30:00	04/09/2023	70
13:30:00	04/09/2023	71
13:30:00	04/09/2023	4
13:30:00	04/09/2023	5
13:30:00	04/09/2023	6
13:30:00	04/09/2023	17
13:30:00	04/09/2023	S2
13:30:00	04/09/2023	55
13:30:00	04/09/2023	62
13:30:00	04/09/2023	63
13:30:00	04/09/2023	2
13:30:00	04/09/2023	4
13:30:00	04/09/2023	1
13:30:00	04/09/2023	13
13:30:00	04/09/2023	105
13:30:00	04/09/2023	123A
13:30:00	04/09/2023	126
13:30:00	04/09/2023	27
13:30:00	04/09/2023	106
13:30:00	04/09/2023	113
15:00:00	04/09/2023	49
15:00:00	04/09/2023	50
15:00:00	04/09/2023	59
15:00:00	04/09/2023	66
15:00:00	04/09/2023	2
15:00:00	04/09/2023	5
15:00:00	04/09/2023	G06
15:00:00	04/09/2023	G07
15:00:00	04/09/2023	009A
15:00:00	04/09/2023	112
15:00:00	04/09/2023	126
15:15:00	04/09/2023	12
15:15:00	04/09/2023	15
15:15:00	04/09/2023	16
15:15:00	04/09/2023	56a
15:15:00	04/09/2023	62
15:15:00	04/09/2023	66
15:15:00	04/09/2023	102
15:15:00	04/09/2023	108
15:15:00	04/09/2023	111
15:15:00	04/09/2023	113
15:30:00	04/09/2023	13
15:30:00	04/09/2023	13
15:30:00	04/09/2023	123A
18:00:00	04/09/2023	13
19:45:00	04/09/2023	13

[Ahmedx]

Share some data to work with (in a format the can be pasted in an MS Excel file)