Forum Discussion
Display top 10 records
Hi All,
I need to display Top 10 latest post from twitter in Power BI based on the time of post. I have connected to my twitter account and there is coolumn called created date.
How to achieve this?
Regards,
Manivannan M
TopN filter? Not really enough information go to on. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi@Manivannan
You can try to use TopN function
Here is a link for your reference:
https://community.powerbi.com/t5/Desktop/Topn-Function/m-p/43764/highlight/true#M16878
Best Regards,
Lin
4 Replies
- Greg_Deckler
Community Champion
TopN filter? Not really enough information go to on. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
- v-lili6-msft
Community Support
Hi@Manivannan
You can try to use TopN function
Here is a link for your reference:
https://community.powerbi.com/t5/Desktop/Topn-Function/m-p/43764/highlight/true#M16878
Best Regards,
Lin
- Manivannan
Helper I
Hi Greg & Lin,
I'm able to achieve it through TopN function. Thanks a lot for the info.
Regards,
Manivannan M
- AFaroukRegular Visitor
Check this tutorial for connecting Power BI with Twitter API
https://www.youtube.com/watch?v=i88CBli0uQc
And in your case you will use count paramater at the same example of the tutorial its get leatest (#count)
Regards