Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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.
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.
Do you have another filter or visualization interacting with said filter?
No I checked again but nothing is interacting with the filter
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |