Forum Discussion

YAmit9012's avatar
YAmit9012
Frequent Visitor
4 years ago
Solved

Limit the result dataset

Hi Everyone, 

 

I have following postgreSQL - 

 

select
Name,
RollNumber,
Address,
ContanctNo,
Standard,
YearOfJoining,
from student
where YearOfJoining='?'
and Standard='?'
order by markes desc limit 5 

 

I need to show Name,RollNumber,Address,ContanctNo,Standard,YearOfJoining  on table visual. 

 

1) To do so I have imported the student from postGreSQL db and applied order by desc on markes column by applying transformation.

2) Now on top of ordered data (student table) , i have created slicer for YearOfJoining and Standard column.

3) After selecting desired value in slicer (YearOfJoining=2021 and Standard =12), i am getting too many rows in table visual , and now I have to select only 5 records.

 

I am not able to find any way so that I can filter only 5 records in final table visual.

 

NOTE : markes value is NULL as of now.

 

Please help. 

 

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi YAmit9012 ,

     

    You want to filter the top five records by sorting, right?

    You can try to use TOP N filter.

     

     

    Reference:  Solved: TopN - Microsoft Power BI Community

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi YAmit9012 ,

     

    You want to filter the top five records by sorting, right?

    You can try to use TOP N filter.

     

     

    Reference:  Solved: TopN - Microsoft Power BI Community

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi YAmit9012 ,


    Could you tell me if your problem has been solved?
    If it is, kindly Accept it as the solution. More people will benefit from it.
    Or you are still confused about it, please provide me with more details about your problem.


    Best Regards,
    Stephen Tao