cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HArkRavA Visitor
Visitor

Basic scatterplot assistance

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_namevaluerole
Org 10ABC
Org 10XYZ
Org 22ABC
Org 20XYZ
Org 31ABC
Org 32XYZ

 

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User I
Super User I

Re: Basic scatterplot assistance

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:

Annotation 2019-10-01 203638.png

 

 

Appreciate your Kudos
Connect with me!

Stay up to date on  linkedin-logo.png
Read my blogs on  powerbi.tips_.png

View solution in original post

1 REPLY 1
Super User I
Super User I

Re: Basic scatterplot assistance

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:

Annotation 2019-10-01 203638.png

 

 

Appreciate your Kudos
Connect with me!

Stay up to date on  linkedin-logo.png
Read my blogs on  powerbi.tips_.png

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors