Forum Discussion
FIlter does not display all the data
Hi!
I created a map displaying zip codes on PowerBI and an associated filter to narrow the data displayed.
But I realize that my filter does not propose all my 527 unique zip codes but only exactly 349. And the 349 zip codes seem to have been selected rather randomly.
Are there any existing limitations to the amount of data a filter can display? And if yes, does anyone know how to get across this issue and display all my data in the filter?
Thanks!
5 Replies
Aron_MooreSolution Specialist
Do all 527 values exist in your data?
When you select a column as a filter it will only populate the filter with the values present in that column.
Yes all my unique zip codes come from a column in a 4500 rows table that I used for the filter. I extracted the data and removed duplicates in the zip codes to find the number.
- Aron_Moore
Do you have another filter or visualization interacting with said filter?
- v-diye-msft
Community Support
Hi miette_d
You might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive or dropbox and share the link to the file. we'd like into it.
