Transform Data mode only show 100 rows

[Anonymous]

Hello,

I'm trying to create a new column based on data that comes from a column in my table. However, when I'm using Power BI's Transform Data screen, and using the Add Column ->Example Column->From Selection, only the first 100 table's rows are shown, which makes it impossible for me to determine the data in the new column, since my table has more than 20000 rows and I need to capture all kind of data variations in this column. Is there a way for Power BI to show more than 100 rows in Transform Data mode?

[shmadhu]

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!

[Viking204]

This worked for me, thanks for the tip!

[mwegener]

Hi @Anonymous ,

was your problem solved?

[V-lianl-msft]

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.

[amitchandak]

@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

[harshnathani]

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!