ArcGIS map with over 3500 rows -can I specify which rows to prioritize in display?

[suraetay]

Hi all,

I'm working on a basic ArcGIS mapping visual based off of a UNION table with more than the 3500 row max allowed for free users. This is overall fine, as our coordinators are filtering the map down to specific regions with considerably less than 3500 addresses, but I'd like the overall map to continually display a subsection of addresses for projects that have been marked as "Unassigned" on the table the visual is pulling from. Right now it looks like it's just pulling in addresses in order of the house number, but is there a way I can change that to pull in those  "Unassigned" project addresses first, then fill in the remaining with the other, non-Unassigned addresses?

[lbendlin · Accepted solution]

You can see how the window is sorted in the DAX query.  See if adding the columns in the desired order to the visual changes the sort order.

[lbendlin · Accepted solution]

You can see how the window is sorted in the DAX query.  See if adding the columns in the desired order to the visual changes the sort order.

[suraetay]

I know that it's sorted by the address itself, starting with the house number. Is there a way to change how it's sorted?

[lbendlin · Accepted solution]

See if adding the columns in the desired order to the visual changes the sort order.

[v-menakakota]

Hi @suraetay ,

I would also take a moment to thank  @lbendlin  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Best Regards, 
Community Support Team

[v-menakakota]

Hi @suraetay ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Best Regards, 
Community Support Team