Forum Discussion
EnhancedScatter Legend and Shape Inputs
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!
- Anonymous2 years agoNot applicable
I am unable to attach the data, so pasting an image here: