Transform Data mode only show 100 rows

I was facing the same issue where I needed more than 100 rows from the example column. I followed the below steps and it seems to work for me.
1. Select and filter the rows from the example column(s) which would capture the required data variations. 
2. Add the new custom column from examples and populate it until Power BI gets the logic right.

3. In the Applied Steps section, delete the filtering you have done in the first step and check if your custom column now has all the variations you wanted. 

When deleting, it warns you that subsequent steps might get affected. But my custom column was the only next step and it turned out to be exactly what I wanted.
Hope this helps. Please let me know if you found more elegant way of doing this.

Thanks!

Hi Anonymous ,

I think it is not possible.

You can click on the Filters to check the Data of that particular Column.

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!

Anonymous , You can create a rank and filter on that at visual level

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/367415

Hi Anonymous ,

I tried. It's impossible. You can come up with ideas to help improve power bi

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

Hi Anonymous ,

was your problem solved?