Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
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
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |