Forum Discussion

melina's avatar
melina
Icon for Helper IV rankHelper IV
9 years ago
Solved

set maximum data row in table

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!

Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    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,

1 Reply

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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,