set maximum data row in table

[melina]

Hi All,

I have used table visualization for Vendor details data. The problem is when too much data. Then the table need to scroll down. I dont want my user to scroll the data because this project will display on TV as smartboard. My idea is set a maximun row data in table. The the rest data will display automatically on the next page. It is possible?

I have plan to use index by setting on the visual filter. But, the problem will comes if my data more that i set in visual filter. Because this data will referesh and update day by day. It is there any others way?

Thanks for your help!

[v-sihou-msft · Accepted solution]

@melina

In DAX, table has no sequence for records internally. To get the maximum row, you must be based on a column like Index or Date. Then you can create a calculated table like below:

Table 2 = FILTER(ALL('Calendar'),'Calendar'[Date]=MAX('Calendar'[Date]))

Regards,