Question about graphics attributes

[Mark]

Hi,

I am trying to create some application that, between other things, will show places at the map (lat. & long.) using different graphics options, such as size, color, shape etc. (getting info from some Excel file).

Up to now, I was succeeded to do it with 4 Excel info columns:     Location      Latitude      Longitude      Size.

I put each column at appropriate place at the Power BI GUI, and I see each point as green circle at appropriate place at the map, with appropriate size.

But I cannot understand how can I change other graphics attributes, such as color and shape (for example).

Is it possible?

Mark.

[greggyb]

Shape: no.

Color: You can use color saturation to set up a color scale based on numeric value.

You can change the color of specific legend entries manually.

[Mark]

Thank you for your answer.

OK, I understand that I cannot change the shape - it always will remain circle.

But what about color - it simply always will be green, with different levels of saturation?

Mark.

[Seth_C_Bauer]

@Mark You can use a legend and select different colors in the format section (Paintbrush)

[Mark]

OK, thank you, I will try it.

But, as I said, I need to get all the info from Excel file, and, as I understand, I cannot change the color using Excel (or any other external option) - only saturation. Is it true?

[greggyb · Accepted solution]

The same thing, but with pictures this time! All of these options are identical regardless of the data source - that's the promise of Power BI, no matter where your data comes from you can treat it all the same in PBI. In this case, the promise is true. The following color options are identical for all sources. It does not matter if your data is coming in from Excel. Here's what @Seth_C_Bauer and I have been saying.

Saturation gives you a range between 2-3 colors based on the evaluation of a measure for the point plotted (depends on divergent or non-divergent)!

Note the measure value in the color saturation well for the map visualNote the definition of data colors in the formatting pane.

Your other option is to use the legend, which automatically assigns a unique color to every legend entry!

Note we've got a field in the legend well for the map visualization!See how we can change the colors for those legend entries manually in the formatting pane of the map visual!

The keen observer will note that we used the same formatting menu, 'Data colors', for each of these options. Legend and color saturation are mutually exclusive in a map.

Have fun with your info from the Excel file.

[Mark]

Thanks a lot for your explanations.

I am a new customer of Power BI, so not all is clear for me, but I will try to do what you are recommended.

Mark.