Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
This should be a pretty simple one.
I have a table with about 10,000 rows.
I am looking for the entry 9419 within the column NLC.
But, as we can see above, even when the maximum number of filter values are loaded (using the 'load more' button at the bottom right of the filter dialog), 9419 is not there.
So 9419 is not in our table...right?
Well...it is...and by rewriting the filter statement in M, I was able to obtain it.
So what's going on here? It seems fairly pointless to have a filter feature that does not accurately reflect what is actually contained in the table. I presume I'm using this tool in the wrong way?? Is there a simple 'point and click' solution to checking whether a given value is present in a column? Never had this issue with filters in Excel, for example.
Solved! Go to Solution.
Hello @Anonymous
this how power query works. It's a transform tool, not a tool to handle the data itself. This is only a preview, and it's only loaded a limited amount of data. The same it happens when you make an Table.ExpandTableColumn. It's reading only a limited amount of rows to analyse the columnheaders.
To filter for a number, use this GUI
as soon the whole table is loaded to Power BI, you have the whole table with all data
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
@Anonymous
You can just use "Filters" --> Equals and enter the number you need. Right above where you entered the number as shown in your pic.
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hello @Anonymous
this how power query works. It's a transform tool, not a tool to handle the data itself. This is only a preview, and it's only loaded a limited amount of data. The same it happens when you make an Table.ExpandTableColumn. It's reading only a limited amount of rows to analyse the columnheaders.
To filter for a number, use this GUI
as soon the whole table is loaded to Power BI, you have the whole table with all data
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!