Show the first 100 rows of each view / source in a table

[joshua1990]

Hello everyone!

I am currently working on a data dictionary.

I have a master data set that contains all ERP Data.

Now I would like to build 1 Report for some End User where they can filter on every source and see the first 100 rows for each source we are working with.

Is there any chance to get this in Power BI?

Is there any function that could populate every column in a table?

[amitchandak]

@joshua1990 , refer if this can help

https://www.sqlbi.com/articles/filtering-the-top-3-products-for-each-category-in-power-bi/

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

[harshnathani]

Hi @joshua1990 ,

See if this trick works for you.

https://www.youtube.com/watch?v=_sxLEGRCo28

Regards,

Harsh Nathani