Scatter chart help -

[jtpiazzamn]

I'm trying to duplicate this scatter chart - I have all of the values calculated, but can't find the right scatter chart. 

X axis - this will display Names of reviewers

y axis - this will display Avg Difference from mean

The bubble size will be the # of evaluations each reviewer did. Do I need to write a measure for this? 

Do you know what kind of chart? 

[ppm1]

It looks like it is not filtering on the Reviewer Name. Do you have a relationship in place between the table with the names and the table with the data?

Or your DAX measure is removing too many filters. Please share your DAX measure expressions, along with a description of your model (tables and relationships).

Pat

[jtpiazzamn]

I added the Reviewer name to the table column via a formula. see below

ReviewerName =

VAR UserID = 'ArcWerx Ratings (2)'[Arcwerx.user.id]

VAR ARCWerxRevName =  

MAXX(FILTER('User List w-competence','User List w-competence'[User.id]=UserID),'User List w-competence'[User.displayName])

RETURN

ARCWerxRevName

I changed the x axis to use the user ID and it looks better

The table only has 1 relationship - connected to a table with userID's to get the name of the user ID. 

Here are the measures I'm using 

Avg Diff from Mean = [Rev Avg Score] - [Rev Mean Score]

Rev Avg Score =

CALCULATE(

    AVERAGE('ArcWerx Ratings (2)'[Arcwerx.value]),

    ALLEXCEPT('ArcWerx Ratings (2)','ArcWerx Ratings (2)'[Arcwerx.suggestion.id],'ArcWerx Ratings (2)'[Arcwerx.user.id]

))

Rev Mean Score =

CALCULATE(

    MEDIAN('ArcWerx Ratings (2)'[Arcwerx.value]),

    ALLEXCEPT('ArcWerx Ratings (2)','ArcWerx Ratings (2)'[Arcwerx.suggestion.id],'ArcWerx Ratings (2)'[Arcwerx.user.id]

))

Thank you! 

[jtpiazzamn]

I'm reposting this so its at the top for better awareness. Any thoughts on why its using just the totals and not the values? 

[jtpiazzamn]

Hello - thank you for your help. I've gotten this far, but the chart still isn't working. The plots on the chart are using just the TOTALs in the data - not the actual values. 

Thoughts? 

[Pragati11]

HI @jtpiazzamn ,

You can definitely create a scatter chart something like this. I tried to create one at my end:

Is it possible for you to share some sample data so that I can try to create the chart you are looking for?

Refer following article on how you can share some sample data:

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[jtpiazzamn]

When using a manually created table - works as expected, but using data set and measures. Only displaying the TOTALS. See below