Basic scatterplot assistance

[HArkRavA]

I am relatively new to Power BI, and am looking for help on how to build a scatterplot, which I think is the best way to accomplish what I'm trying to do.

The base data can be simplified as the following:

organization_name	value	role
Org 1	0	ABC
Org 1	0	XYZ
Org 2	2	ABC
Org 2	0	XYZ
Org 3	1	ABC
Org 3	2	XYZ

Consider conducting surveys of many organizations, and that the surveys are completed by two different people (in different roles) at each organization. The data above represents a single survey question and the range on this survey question is 0-2. I'd like to visualize the differences/similarities between responses per role within each org. In theory, this would mean making the x-axis the values of role XYZ and the y-axis the values of role ABC. Then each plot point would be a given organization. 

Can I accomplish this with the data formatted as-is? I don't think I can use the same column (even with filters) as the x-axis and y-axis and can't figure out how to proceed. Any help would be much appreciated.

[SteveCampbell · Accepted solution]

I don't think a scatter plot is what you want here. Scatter plot shows the relationship between two variables (i.e. numeric data points).

You only have one variable, but are trying to split between two categories (i.e. text fields - company name and role)

I think a better fit would be a clustered column. You can put company in axis and role in legend, or the other way round depending on the point you are trying to make:

Appreciate your Kudos
Connect with me!

Stay up to date on  
Read my blogs on