Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everyone,
Is there any possibility to display all values and not havng this limit?
Thank you
Solved! Go to Solution.
Good.
I just killed my PC trying to test this.
----
I got the 'load more' to appear , once I changed the 'preview all rows option' to 'based on all rows' and refreshed.
----
I also changed some of the 'allow preview rows to load in background on query options but I don't know if this had any effect'.
If it doesn't work, sort the data descending (as you've already done) and choose from list OR just edit the formula bar - e.g. each ([SalesKey] = 2 or [SalesKey] = 3 or ......)
Good.
I just killed my PC trying to test this.
----
I got the 'load more' to appear , once I changed the 'preview all rows option' to 'based on all rows' and refreshed.
----
I also changed some of the 'allow preview rows to load in background on query options but I don't know if this had any effect'.
If it doesn't work, sort the data descending (as you've already done) and choose from list OR just edit the formula bar - e.g. each ([SalesKey] = 2 or [SalesKey] = 3 or ......)
Yes, that's what I did and it really works
Thanks a lot!
Has the 'load more' been taken away on the auto-filtering?
----
Anyway maybe I can help you get round this. You can choose a value from the dropdown and then edit it in the formula bar to replace it with what you want.
Is that what you are trying to do?
What I am trying to do is to filter various data by their id so that they do not appear, the problem is that there are many and it is done faster here than by a formula. So, for example, I can filter by id 35 or134 or 1678 or 2789 if I wanted to but it won't let me see more than id 2118.
The 'load more' been taken away on the auto-filtering, as you can ee in the foto, if we re talking of the same thing, maybe I misunderstood.
Hi,
You mean here?
But as far as I can see, it doesn't change anything 😞
Click on 'column profiling based on top 1000 rows' at the bottom of the screen. Select the other option