How to fetch all the records/data of a dimension in filter component in Dashboard using universe

Hi Guys,

I have an issue in loading all the values of the dimension in filter component. I had built a query from Universe. After which I have inserted into spreadsheet and selected only 8 rows in the Excel spreadsheet. I used filter component for country dimension and speadsheet table to view the data which I saw at the Preview results while building a query. When I preview it I see only the 8 records for country in the filter component. How to fetch all the 90 country records of a dimension in the filter component in order to select other countries? Can anyone tell me the process of viewing all the list /values of a dimension?

Kindly help me. Its urgent.

Thanks,

Anila.