EnhancedScatter Legend and Shape Inputs

[Anonymous]

I am trying to build a scatter plot using EnchancedScatter visualization in PBI that I was able to import from Microsoft App Source. I want to have the data points be the same color based on the same Legend value and the same shape based on the same value of the input to the Shape field. How can I do that? Is there any other way of doing this, ie plot the data on scatter plot using a legend for colors and another legend for the shapes? For example: Plot "Sales" and "Product" on the X and Y axes and then split the data by "Country" for colors and "Quarter" for shapes (such as triangles, circles, squares, etc.)

[Anonymous]

Thanks a lot for responding to my question. I am attaching a sample data. It has 4 columns "Product", "Sales", "Country" and "Quarter". I need to plot the raw values of "Product" and "Sales" on the X and Y axes of the scatter plot respectively, then color code all the scatter points with the same country as the same color. Within each color, I want to symbol-code the data in the same quarter as the same symbol (within each color-coded country).

I am having several issues though. Firstly, EnhancedScatter does not allow me to choose the raw X, Y value as such. I do not want to use any of the statistics as follows:

How can I choose the X, Y raw values?

Secondly, I chose the Legend as "Country" and Shape as "Quarter". However, it doesn't simply choose the value of the "Quarter" but gives me the following options, none of which work:

The graph that I am looking for, is as follows:

Is it possible to generate a graph like this in Power BI?

Thanks again!

[Anonymous]

I am unable to attach the data, so pasting an image here:

[Anonymous]

Hi  @Anonymous ,

You can download the sample data and related videos for Enhanced Scatter from the link below, which can help you customize colors and use shapes correctly. 

In the visual, you can set the colors for each category in the Legend under Data colors; whatever color you set, that color will be displayed.

You may also consider adding a color column and placing it into Customized Color to display the corresponding color.

Place the created [Shape] column into Shape.

Refer to:

Enhanced Scatter (microsoft.com)

Best Regards,

Liu Yang

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