Power BI Map layering

[cbouichi]

Hallo everybody,

I got 2 sets in 1 layer that is displaying in the ESRI map.

is it possible to change the color van set 1 en set 2?

I tried mapbox also, with no results.

so what i want 2 different colors points in 1 map.

greetz.

C. bouichi

[v-jiascu-msft]

Hi @cbouichi,

You can add the set names as a legend. Please refer to the snapshots below.

Best Regards,

Dale

[cbouichi]

 i been looking for this option "legend". but i dont have it. see picture (Version 2.56.5023.1021 64-bit maart 2018)

[v-jiascu-msft]

Hi @cbouichi,

If it's ArcGIS map, you need to add it in the "Color" field. Can you share some sample data? There could be something wrong with the column "Layer set".

Best Regards,

Dale

[cbouichi]

Hi @v-jiascu-msft,

first of all thanks for the help.

Layer set is a column with the following formula:

Layer set = IF(Wegenschouw[objectID]=BLANK();1;2).

the datasheet is a result of 2 tables that been append too one table.

its connected too a SQL server, how can i share some sample dat?

[v-jiascu-msft]

Hi @cbouichi,

You can upload the pbix file to the cloud drive like OneDrive, Dropbox if you can, then share the link here. If you can't share the file, you can post samples of the tables and the relationships here. Please mask the private data first.

Best Regards,

Dale

[cbouichi]

removed data

[v-jiascu-msft]

Hi @cbouichi,

You had filtered out the type 1. That is why there is only one color. Please clear the filter and try again.

Best Regards,

Dale

[cbouichi]

I see you changed the colors, how did you do that?

i clear the filter but no options to set different colors

[v-jiascu-msft · Accepted solution]

Yes, the default color isn't that good. Please follow the steps in the snapshot.

Best Regards,

Dale

[cbouichi]

Thanks alot @v-jiascu-msft.

Offcourse the next problem appears.

If i choose the related column chart. set 2 disappear.

it should stay. any idea or should i make a new post?

Greets,

Happy charaf