Add dynamic map point based on selection

[Jebilaya]

I have a maps visual and a table that allows the user to select a store.  I have another table that contains the postcode for the store and I would like a fixed point on the map visual that has a different colour that shows the store location.

I can't see anywhere within the visual formatting that this would be feasible.  Only option I could think of is creating a new dynamic table that creates the data based on the store selection and adds in the store postcode then Legend could be used but not sure how I would do that?

[v-yanjiang-msft]

Hi @Jebilaya ，

Do you want to do conditional formatting for the bubbles in the map? If so, here's my solution.

Sample:

Create a measure:

Color =
SWITCH (
    MAX ( 'Table'[Location] ),
    "China", "Red",
    "USA", "Blue",
    "UK", "Green",
    "Japan", "Black"
)

Then in the visualizations pane>Bubbles>Colors, click the fx button.

Select "Field value" and measure Color in the dialog.

Result:

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jebilaya]

Hi @v-yanjiang-msft 

Colouring the drops is not what i'm looking for here.  I need to be able to plot one static location per selection i.e. if the user selects store A it should show all of the bubbles for Store A as set out in my screenshot above but there should also be a marker for the actual store location