Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
billlyh96
New Member

Powerbi/Power Query Editor dropdown/filter not showing

I am currently using power bi and am transforming the data using power query editor. As shown in the image below, why does alot of my column not show any filter data under the drop down ? 
I do have a big data load but is that the only reason why it is unable to show due to the large set of data in it ? It has only about 7 different type of values under sales channel.
With this issue , i'm unable to filter the sales channel accordingly. And if so, is there any other way i am able to filter the data to show specifically a few of the selected sales channel everytime I power query it ?
Please do help me with this issue. Thank you ! 

 

billlyh96_0-1695808685689.png

 

1 REPLY 1
christinepayton
Super User
Super User

If you want to filter on things that are not present in the dropdown, just select the "text filters" option in your screenshot and type in the values there. There's also the option to not use the 1000 row preview in the bottom corner of the PQ window if you want to try toggling that to see all values. 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.