I am hoping to implement some multi-select parameters in a Power BI report.
Issue
I have a table of approx. 3 million rows (people) who I want to plot subsections of (selectable by the user) on a map - I am aware of the 30k limit on the map visual and these subsections will each be well under this 30k limit; however when choosing smaller cohorts patients are still missing. I have tested Lat/Long data, Postcode data and checking the underlying data and can see Power BI is recognising the people it needs to map, but it is as if the 30k limit is being applied before the filter.
Solutions Tried
I have got a verion of this working using parameters to push the 'filter' back to the query, limiting the data before import, but this does not allow multi-selection
I have also tried following Chris Webb's blog post (https://blog.crossjoin.co.uk/2021/10/10/multi-value-parameters-in-power-query-online/) - but I cant get this to work with a dynamic list (generated from a query) - or see how you can edit these parameters in the report like you can in desktop/reports published from desktop (to make it easy for the user to chop and change their selections.
Any advice as to if this is possible at the moment/best way to achieve this?!
